v.1.1.54370Improvement

Added Data Set Alias Creation Feature

Official CH changelog text
Added the ability to create aliases for data sets. Example: WITH (1, 2, 3) AS set SELECT number IN set FROM system.numbers LIMIT 10.
Added support for creating aliases for data sets in queries using the WITH clause with set expressions.

Why it matters

This feature allows users to define named sets or collections within queries, making it easier to reuse and reference fixed data sets. It enhances query readability and simplifies working with constant sets in expressions such as membership checks.

How to use it

Use the WITH clause to define a set alias before the query. For example:

WITH (1, 2, 3) AS set
SELECT number IN set
FROM system.numbers
LIMIT 10
PreviousNext