I recommend to model after ClickHouse ODBC integration: https://clickhouse.com/docs/en/sql-reference/table-functions/odbc https://clickhouse.com/docs/en/sql-ref

I recommend to model after ClickHouse ODBC integration: https://clickhouse.com/docs/en/sql-reference/table-functions/odbc https://clickhouse.com/docs/en/sql-reference/table-functions... It already has the items from your list, like the predicate push-down. Plus, it is memory-safe, thanks to clickhouse-odbc-bridge which runs as a separate process and does not poison the main server process's address space. PS. I'm one of developers of the ODBC integration.