Intergrate with jupysql

[auxten]

Something like https://jupysql.ploomber.io/en/latest/integrations/duckdb.html
chdb needs a Python DB API 2.0 wrapper to run with jupysql.

[idomic]

If that works well, we can add a guide to our docs as well!
We do have integration with click house so I assume it'll be pretty straight forward!

[edublancas]

@auxten: can chdb use the clickhouse sqlalchemy driver? If so, it should work without changes: https://jupysql.ploomber.io/en/latest/integrations/clickhouse.html

if that doesn't work, we're working on adding support for any driver that follows the DB 2.0 spec

[auxten]

Thank you @idomic
I need to dive into duckdb and clickhouse-connect to see how to do that @edublancas

[auxten]

It seems @laodouya is working on the Python DB API 2.0 #30

[edublancas]

great! we added support for DB API 2.0 in Jupysql 0.7.2

[lmangani]

great! we added support for DB API 2.0 in Jupysql 0.7.2

If you want you can test the changes ahead or release and provide any feedback: #30