Support chdb

[fithisux]

Is your feature request related to a problem? Please describe. This issue does not fix a problem.

Describe the solution you'd like I would like to use dbt to run models on chdb. Like in DuckDB.

Describe alternatives you've considered I would like to avoid using a full clickhouse subscription, since I am mostly interested in pedagogical use or local use.

Additional context No thing else

[OneCyrus]

that would be a great addition. just added my vote.

[ThomAub]

I started to work on it and the current design is to specify chdb as the driver

chdb-dev:
      type: clickhouse
      driver: chdb
      chdb_state_dir: ""     # a directory use for persistent session 
      chdb_dump_dir: ""    # a directory of sql files that will be loaded as initial state, for sources for examples 
      threads: 1
      user: dbt_test
      password: dbt_password
      schema: taxis_dbt