New functions you might have missed in 2025

In 2025, ClickHouse introduced 119 new functions, with significant additions in each version update throughout the year. Among these are various functions like `mapContainsValueLike`, which checks if a map contains a value matching a specific pattern, and `perimeterCartesian`, which calculates the perimeter of a geometry in a Cartesian coordinate system. The `HMAC` function, also introduced, offers cryptographic message authentication. Functions such as `argAndMax` and `argAndMin` allow for advanced querying capabilities, such as retrieving the maximum or minimum priced property along with its location. Financial computations are enhanced with `financialInternalRateOfReturn`, which calculates annual investment returns. Other notable functions include `stringBytesUniq` for counting unique bytes in a string, `toInterval` for creating interval values from numbers, and `timeSeriesRange`, which generates a range of timestamps. These functions collectively improve the data processing, querying, and analytical capabilities of ClickHouse, providing users with diverse tools to handle complex data tasks efficiently.