Would love to see a benchmark comparing SQLite, DuckDB and this SQLite/DuckDB combo with the same queries and data.
Is this adapter copying the contents of the SQLite db into DuckDBs own memory layout in order to optimise the queries or is it just “proxying” to the SQLite library?