ClickHouse comes with a handy query formatter included.
You can use it from the command line, for example:
$ echo "Select a + b as value, max(date) as max_date from my_table where c > 0 group by value order by max_date" | clickhouse format
a + b AS value,
max(date) AS max_date
WHERE c > 0
GROUP BY value
ORDER BY max_date ASC