v.24.11Improvement

Added Natural Camel-Case Aliases for Aggregation Functions in ClickHouse

Official CH changelog text
Added aliases anyRespectNulls, firstValueRespectNulls, and anyValueRespectNulls for aggregation function any. Also added aliases anyLastRespectNulls and lastValueRespectNulls for aggregation function anyLast. This allows using more natural camel-case-only syntax rather than mixed camel-case/underscore syntax, for example: SELECT anyLastRespectNullsStateIf instead of anyLast_respect_nullsStateIf. #71403 (Peter Nguyen).
Added camel-case-only aliases for the any and anyLast aggregation functions that support the _respect_nulls variants, enabling a more natural and consistent syntax.

Why it matters

The feature addresses the inconsistency in naming conventions by providing camel-case-only aliases for aggregation functions with the _respect_nulls suffix. This improves readability and ease of use by avoiding mixed camel-case and underscore styles in function names.

How to use it

Users can simply use the new camel-case-only aliases such as anyRespectNulls, firstValueRespectNulls, anyValueRespectNulls, anyLastRespectNulls, and lastValueRespectNulls directly in their queries instead of the underscore-separated variants. For example: SELECT anyLastRespectNullsStateIf(...) instead of anyLast_respect_nullsStateIf(...).

Related resources

PreviousNext