ClickHouse Release 25.11

ClickHouse version 25.11 introduces a range of enhancements, including 24 new features, 27 performance optimizations, and 97 bug fixes, with significant contributions from a diverse group of new contributors. The release introduces ACME (Let's Encrypt) integration for automatic TLS certificate provisioning and expands parallel processing capabilities for improved GROUP BY operations on small integer keys, optimizing query performance. Additionally, the update features projections as secondary indices, which enhance query efficiency by reducing storage overhead while maintaining primary index benefits. The release also includes optimizations for DISTINCT queries using projections, and introduces new functions such as argAndMax and argAndMin for retrieving associated maximum and minimum values. New functionalities like fractional LIMIT and OFFSET allow for more granular data retrieval, and EXECUTE AS user functionality facilitates query execution on behalf of another user, enhancing access rights management. These updates collectively aim to improve both the speed and flexibility of data processing and querying within the ClickHouse platform.