GROUP BY 1?

[Thomas Wang]

Hi Calcite community,

I'm trying to validate a SQL like the one below.

SELECT user_id, COUNT(1) cnt FROM schema.table_name GROUP BY 1;

It looks like in the default configuration, GROUP BY 1 is not considered
valid. It complains user_id is not being grouped.

Is there a quick configuration that enables syntax like that? I'm looking
at SqlParser.Config, but none of them seems to be relevant to this.

Thanks.

Thomas