v.22.9Improvement

Add Automatic SQL Commenting in ClickHouse Client

Official CH changelog text
Add ability to automatically comment SQL queries in clickhouse-client/local (with Alt-#, like in readline). #41224 (Azat Khuzhin).
Added the ability to automatically comment SQL queries in clickhouse-client and clickhouse-local using the Alt-# shortcut, similar to readline behavior.

Why it matters

This feature improves user experience by enabling quick commenting of SQL queries directly in interactive ClickHouse clients, streamlining query editing and debugging workflows.

How to use it

In clickhouse-client or clickhouse-local, press Alt-# while editing a query to toggle comments on the selected lines or current line, facilitating faster query editing without manual insertion of comment syntax.

Related resources

PreviousNext