v.1.1.54380Improvement

Subqueries in Brackets for Enhanced Readability

Official CH changelog text
Subqueries can be wrapped in () brackets to enhance query readability. For example: (SELECT 1) UNION ALL (SELECT 1).
Support for wrapping subqueries in parentheses to improve query readability.

Why it matters

This feature allows users to enclose subqueries in () brackets, making complex queries easier to read and understand by visually separating subqueries.

How to use it

Simply wrap your subqueries in parentheses, for example:

(SELECT 1) UNION ALL (SELECT 1)
PreviousNext