SET memory_limit = '64GB';
SET threads = 16;
SET preserve_insertion_order = false;
SET temp_directory = '/tmp/duckdb';

COPY (
    SELECT *
    FROM 'datasets/narinfos-2026-01-06T01-13Z.parquet'
    WHERE
        pname LIKE 'nixos-%.iso'
        OR pname LIKE 'nixos-%.img'
        OR pname LIKE 'nixos-amazon-image-%'
) TO 'datasets/nixos-images-2026-01-06T01-13Z.parquet' (FORMAT PARQUET);