v.23.3Improvement

Support for Subquery in Parameterized Views

Support for subquery in parameterized views; resolves #46741 #47725 (SmitaRKulkarni).
Added support for subqueries in parameterized views in ClickHouse.

Why it matters

This feature solves the limitation of parameterized views not supporting subqueries, enabling users to create more flexible and dynamic views that can reference complex queries as parameters.

How to use it

Users can now define parameterized views that include subqueries by specifying the subquery within the parameterized view definition as usual. The system will correctly handle and execute these subqueries within the context of the parameterized view.