ClickHouse/clickhouse-connect v0.14.0

on GitHub

High level notes

This release is primarily focused on preparing the path to 1.0.0. It introduces a handful of breaking changes and deprecation warnings for APIs that will be removed or finalized in 1.0.0. If your code uses any of the deprecated parameters, you'll now see DeprecationWarnings with clear migration guidance and highly recommend addressing these before upgrading to 1.0.0 when it ships.

Breaking Changes

• apply_server_timezone renamed to tz_source. Options are "auto" (the default), "server", or "local". The old parameter currently still works with a deprecation warning. #670
• utc_tz_aware renamed to tz_mode. Options are "naive_utc" (the default), "aware", or "schema". The old parameter still currently still works with a deprecation warning. #664
• Removed Object('json') type. This was a legacy experimental JSON type has been removed in favor of the new JSON type in ClickHouse. #666

Deprecations

• Pandas 1.x support is deprecated and will be removed in 1.0.0. #667
• There's a async-native client based on clickhouse-connect v0.11.0 that is available for testing via pip install clickhouse_connect[async]==0.12.0rc1. A FutureWarning advertising this will now be emitted on creation of the (to be legacy) async client. #672

Experimental

• Python 3.14 free-threading (cp314t) wheel builds for all platforms. #660

Improvements

• Fix issue where sending redundant settings is skipped. #639
• Add support for SAMPLE in SQLAlchemy dialect. #656

New Contributors

• @bsushmith made their first contribution in #656

Full Changelog: v0.13.0...v0.14.0