Skip to content

Revisit GROUP BY translation for BigQuery #391

Description

@schuemie

Currently SqlRender translates GROUP BY statements by replacing the column names with column numbers:

translate("SELECT f(a) AS my_value, COUNT(*) AS my_count FROM t GROUP BY f(a);", targetDialect = "bigquery")
# "select f(a) as my_value, count(*) as my_count  from t  group by  1 ;"

As far as I can tell, this is no longer needed, and it would simply things a lot if we can remove it.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions