ClickHouse/clickhouse-connect v1.1.0a2 on GitHub

1.1.0a2 — Alpha Preview (Bug-fix follow-up)

Quick follow-up to 1.1.0a1, rebased on 1.0.0rc3 so the rc3 insert-retry fix is included. Everything from 1.1.0a1 still applies. See that release for the full preview overview.

Installation

pip install clickhouse-connect==1.1.0a2

# To use the Alembic integration:
pip install "clickhouse-connect[alembic]==1.1.0a2"

Fixed in this preview

SQLAlchemy: ClickHouse Select modifiers preserved through the ORM compile path. FINAL, SAMPLE, PREWHERE, and LIMIT BY were silently dropped when a select() was built from ORM-mapped attributes (e.g. select(Event.id)) rather than Core columns. The ORM compile path rebuilds the inner Select via Select._create_raw_select, which discarded the modifier instance attributes — so the compiled SQL emitted no modifier. The compiler now falls back to compile_state.select_statement to recover them. Closes #730.
Inserts: rebuild body on connection-reset retry (inherited from 1.0.0rc3). Fixes intermittent Code: 62. Empty query. (SYNTAX_ERROR) on inserts when a pooled keep-alive connection is reset between attempts; the retry path now rebuilds the insert body instead of replaying an already-drained generator. Affects both sync and async clients. Closes #731.

Feedback

Please keep filing issues at https://github.com/ClickHouse/clickhouse-connect/issues with the alembic or sqlalchemy label.

Full changelog

See CHANGELOG.md for the complete entry.