v.25.6Improvement

Support anyLast_respect_nulls and any_respect_nulls as a SimpleAggregateFunction

Support anyLast_respect_nulls and any_respect_nulls as a SimpleAggregateFunction. #80219 (Diskein).
Added support for anyLast_respect_nulls and any_respect_nulls as SimpleAggregateFunctions in ClickHouse.

Why it matters

This feature allows users to apply the aggregation functions anyLast_respect_nulls and any_respect_nulls within the SimpleAggregateFunction wrapper. It addresses the need to respect NULL values during aggregation, providing more precise control when aggregating values that may contain NULLs.

How to use it

Users can now use anyLast_respect_nulls and any_respect_nulls by specifying them inside SimpleAggregateFunction like so:

SELECT <code>SimpleAggregateFunction</code>(<code>anyLast_respect_nulls</code>, <column>) FROM <table>;

or
SELECT <code>SimpleAggregateFunction</code>(<code>any_respect_nulls</code>, <column>) FROM <table>;