v.24.10New Feature

Allow Parameterized SQL Aliases

Allow parametrised SQL aliases. #50665 (Anton Kozlov).
Introduces support for parameterized SQL aliases in ClickHouse, enabling more flexible and reusable query expressions.

Why it matters

This feature allows users to define SQL aliases that accept parameters, improving query modularity and reducing repetition by enabling dynamic alias substitution based on input parameters.

How to use it

Users can define aliases that take parameters within their SQL queries and invoke these aliases by passing arguments, enhancing SQL alias functionality and query expressiveness.