ClickHouse version 25.2 introduces 12 new features, 15 performance optimizations, and 72 bug fixes. The release includes improved parallel hash join performance, Parquet bloom filter writing, transitive condition inference for queries, a backup database engine, delta Rust kernel integration, and more. A special welcome is extended to the new contributors who have made significant contributions to ClickHouse's community growth. The version also sees improvements in join performance, including faster parallel hash joins, which can fully utilize all CPU cores and complete faster. Additionally, Bloom filters are introduced when writing Parquet files, leading to a 30-40% speed improvement for certain queries. Transitive condition inference is also supported, allowing the query engine to automatically deduce and utilize additional conditions to enhance filtering efficiency. A backup database engine is introduced, enabling users to instantly attach tables/databases from backups in read-only mode. Delta Lake support with the help of a library from Databricks is implemented, although it's still in experimental mode. New formats for HTTP event streaming are also added, including JSONCompactEachRowWithProgress and JSONCompactStringsEachRowWithProgress, which stream newline-delimited JSON events as soon as they appear.