ClickHouse Release 25.12

ClickHouse version 25.12 introduces significant performance enhancements and new features, including 26 new functionalities, 31 performance optimizations, and 129 bug fixes. Notable improvements include faster execution of Top-N queries through data skipping indexes, which reduce the number of rows processed, and enhanced lazy reading via a join-style execution model, which optimizes deferred reading of non-ordering columns. The update also features a more efficient join reordering algorithm, DPsize, for INNER JOINs, which explores richer join orders to produce better execution plans. Additionally, the version marks the text index moving to beta, allowing efficient text searches with various tokenization options. Other enhancements include supporting non-constant IN lists, introducing the HMAC function for message authentication, and new dictionary capabilities for fast key-value lookups. These improvements collectively aim to boost the efficiency and scalability of ClickHouse in handling complex analytical workloads.