> GROUP BY 1, 2, 3
It is not ANSI SQL.
Nevertheless, it is already available in ClickHouse as well under `enable_positional_arguments` setting and we are considering making it enabled by default.
Ooooh.
Is there a way to turn unquoted column and table names case insensitive too? Thats like the second biggest annoyance.
I am still somewhat salty about not being able to do GROUP BY 1, 2, 3 :)
> You are right that ClickHouse requires attention and skills to get the best performance. However, that includes fixed, low-latency use cases like real-time marketing that Snowflake simply does not handle. ClickHouse and Snowflake aren't interchangeable for these use cases.
Yup, that was my point.