This is great work, happy to see DuckDB usage in this space. Related self plug, i made a HTS file formats reader extension rgenomicsetl.r-universe.dev/Rduckhts that allow fast imports directly into duckb and avoid RSamtools and al. There are community readers for single cell formats
Rduckhts: 'DuckDB' High Throughput Sequencing File Formats Reader Extension
Bundles the 'duckhts' 'DuckDB' extension for reading High Throughput Sequencing file formats with 'DuckDB'. The 'DuckDB' C extension API <https://duckdb.org/docs/stable/clients/c/api> and its 'htslib'...
rgenomicsetl.r-universe.dev