v.22.7New Feature

Support window function expressions in ClickHouse

Support expressions with window functions. Closes #19857. #37848 (Dmitry Novik).
Support expressions with window functions in ClickHouse queries.

Why it matters

This feature enables the use of window functions directly within expressions, allowing more advanced and flexible analytical queries. It solves the limitation of not being able to combine window functions seamlessly inside expressions, improving query expressiveness and performance for analytical workloads.

How to use it

Users can now include window functions inside expressions in their SQL queries. For example, you can use window functions within the SELECT clause or WITH expressions as part of complex calculations and aggregations.