ClickHouse 25.7 introduces lightweight updates using patch-part mechanisms that make SQL UPDATE statements up to 1,000× faster, AI-powered SQL generation with OpenAI/Anthropic integration, and significant performance improvements for count() aggregations (20-30% faster) and JOIN operations. The release also adds native Geo Parquet type support, new geospatial functions for polygon intersection detection, and enhanced security features including parameterized user creation and granular read/write permissions for external data sources.
Table of contents
New ContributorsLightweight updatesAI-powered SQL generationSpeed-up for simple aggregationsOptimizations for JOINsNative support for Geo Parquet typesNew Geospatial functionsSecurity featuresSort: