The count() invocation is a small but excellent feature in ClickHouse. There are many other great dialect extensions. -If combinators are another great example.

The count() invocation is a small but excellent feature in ClickHouse. There are many other great dialect extensions. -If combinators are another great example. [0] SQL would be a better language if there had been more innovation focused on code usability over its long history. [0] https://clickhouse.com/docs/en/sql-reference/aggregate-functions/combinators#-if https://clickhouse.com/docs/en/sql-reference/aggregate-funct...