v.22.12New Feature

Add FROM table SELECT column syntax

Add FROM table SELECT column syntax. #41095 (Nikolay Degterinsky).
Introduces the ability to use the FROM table SELECT column syntax in ClickHouse queries.

Why it matters

This feature simplifies query syntax by allowing users to write queries starting directly with FROM, improving readability and aligning with common SQL patterns. It helps users write more concise and intuitive SELECT statements.

How to use it

Users can write queries using the new syntax as follows:

FROM <table_name> SELECT <column_name>

This can be used wherever a SELECT statement is valid, enabling abbreviated query forms without an explicit initial SELECT keyword.