clickhouse-sqlalchemy
clickhouse-sqlalchemy copied to clipboard
xzkostyan
ClickHouse dialect for SQLAlchemy
We discover than requests like `select(table1).join(table2, table2.id == table1.table2Id).where([...])` didn't work with clickhouse-sqlalchemy but did work with standard sqlalchemy because `select(table1).join(table2, table2.id == table1.table2Id)` is a `Select` object in sqlalchemy2....
Adding `SETTINGS final = 1` in the end of the query. This is a useful ClickHouse feature to apply FINAL to all tables in the query: _"Automatically applies [FINAL](https://clickhouse.com/docs/en/sql-reference/statements/select/from#final-modifier) modifier...
The current example leads to the following error with sqlalchemy > 2: `TypeError: MetaData.__init__() got an unexpected keyword argument 'bind'` Maybe fixes this: https://github.com/xzkostyan/clickhouse-sqlalchemy/issues/261
**Describe the bug** The bug is when there is a special character in the password, the problem seems to be in the file `drives/native/base.py` where the password and the username...
**Describe the bug** When you run migration alembic couldn't create table alembic_version **To Reproduce** No migrations files in versions folder of alembic. Docker-file ``` clickhouse-db: image: clickhouse/clickhouse-server:23.8.9-alpine container_name: cp-clickhouse-db environment:...
**Describe the bug** The collate sqlalchemy function is not correctly handled in the Clickhouse dialect **To Reproduce** from sqlalchemy.sql.operators import collate `query.collate(asc("display_name"), "en"))` it generates the following query: `SELECT ......
Bulk update fails through click house driver, at is is detected as insert clickhouse_driver/client.py", line 367, in execute is_insert = isinstance(params, (list, tuple, types.GeneratorType)) Following SQL Alchemy query does not...
I have a query which increments the column by one: query = ( update(Table) .filter(Table.id == '123') .values(counter=Table.counter + 1) ) session.connection().execute(query) This issues ALTER TABLE table UPDATE counter =...
When initially creating a migration file using `alembic revision --autogenerate -m "Init"`, a migration file is generated successfully, and it can be executed without issues using the `alembic upgrade head`...
**Describe the bug** Is there an easy way to use clickhouse-sqlalchemy with https://github.com/chdb-io/chdb/, for use cases like integration tests? It looks like the only available drivers are `native` `http` or...
