v.23.7New Feature

Add any_value as compatibility alias for any aggregate function

Add any_value as a compatibility alias for any aggregate function. Closes #52140. #52147 (flynn).
Added any_value as a compatibility alias for the any aggregate function.

Why it matters

This feature provides compatibility for users migrating from other SQL databases or tools that use any_value for getting an arbitrary value from a group, aligning ClickHouse's functionality with common SQL conventions and improving user experience.

How to use it

Use the any_value aggregate function in your queries exactly as you would use the any function, for example:

SELECT any_value(column_name) FROM table_name GROUP BY grouping_column