v.24.10New Feature

A Simple SELECT Query with Implicit SELECT for Calculator-Style Expressions

Official CH changelog text
A simple SELECT query can be written with implicit SELECT to enable calculator-style expressions, e.g., ch "1 + 2". This is controlled by a new setting, implicit_select. #68502 (Alexey Milovidov).
Introduces the implicit_select setting to allow simple expressions to be executed without explicitly writing a SELECT statement, enabling calculator-style queries like ch "1 + 2".

Why it matters

This feature simplifies running basic expressions by eliminating the need to write full SELECT queries, making quick calculations and simple expressions more accessible and user-friendly.

How to use it

Enable the feature by setting implicit_select to 1 or true. For example, you can execute simple expressions directly via the command line or client without the SELECT keyword: ch "1 + 2".

Related resources

PreviousNext