ClickHouse version 25.6 introduces a range of enhancements, including 25 new features, 32 performance optimizations, and 105 bug fixes, with a focus on ensuring consistent data snapshots across all subqueries and table references within a query. Notably, this release allows filtering by multiple projections and introduces JSON support in Parquet, Time, and Time64 data types for enhanced compatibility with other SQL DBMS. The update also includes new system tables like codecs and iceberg_history for improved data management and insights, alongside a significant optimization in the Bloom filter index that resulted in a 40% reduction in CPU usage during high traffic spikes, as experienced by OpenAI. Additionally, the release features a new command-line tool, chdig, for real-time monitoring and diagnostics, providing detailed views of query performance and server behavior.