We add ClickHouse as a new product type to the builtin sql-mode in Emacs. That
way, we get syntax highlighting and can communicate with the DB using the CLI
clickhouse-client.
Note that the client assumes being run in a fully-functional terminal. While
running a query, it will print updated statistics every 100ms. Inside Emacs,
with the comint interface, these messages accumulate rather than update in
place, which is kind of messy (including some coloring). I failed to disable
this behavior so far, but there is a parameter to control the frequency of these
updates in microseconds. I use the following query to increase it to 10 seconds:
-- 10 seconds in microseconds SET interactive_delay = 10000000;