v.1.1.54276New Feature

Added Optional WITH Clause for SELECT Query

Official CH changelog text
Added an optional WITH section for a SELECT query. Example query: WITH 1+1 AS a SELECT a, a*a
Added an optional WITH clause for SELECT queries to allow defining expressions or aliases that can be reused within the query.

Why it matters

This feature was created to improve query readability and maintainability by allowing users to define intermediate computed values or aliases once and reuse them multiple times in a SELECT statement. It reduces redundancy and simplifies complex expressions, making queries easier to write and understand.

How to use it

Use the optional WITH clause before the SELECT keyword to define aliases or expressions. For example:

WITH 1+1 AS a 
SELECT a, a * a

This defines a as 1+1 and then uses a in the SELECT list.
PreviousNext