I've created an ODBC DuckDB extension to query any database that has an ODBC driver. It's modeled after the fantastic official Postgres scanner extension <a href="https://github.com/duckdblabs/postgres_scanner">https://github.com/duckdblabs/postgres_scanner</a>.<p>It supports fetching rowsets in batches to minimize network overhead and defaults to the default DuckDB vector size of 2048.<p>I've tested it against the IBM DB2 & Postgres ODBC drivers and will continue to test and add support for all major databases. If you've got one you'd like to see let me know in the comments.<p>I've got plenty of improvements in the pipeline including:<p><pre><code> - Write to ODBC database
- Predicate push down
- Automatic catalog discovery
- Performance benchmarks
- Configurable batch size
- Relative & absolute cursors
- OS X builds using rosetta for databases without native aarch64 drivers (IBM/Oracle)</code></pre>