v.20.10Improvement

COLUMNS Function Updated to Apply Column Transformers

Official CH changelog text
Now COLUMNS can be used to wrap over a list of columns and apply column transformers afterwards. #14775 (Amos Bird).
COLUMNS is a new feature that allows users to wrap a list of columns and apply column transformers to them sequentially in queries.

Why it matters

This feature simplifies the process of applying multiple column transformers by grouping columns together before applying transformations, improving query readability and maintainability.

How to use it

Use the COLUMNS keyword to wrap the desired columns and then apply column transformers on the entire group. For example:

SELECT COLUMNS(column1, column2) <transformers> FROM table

Related resources

PreviousNext