🪲 GROUP BY name collisions

[joocer]

Thank you for taking the time to report a problem with Opteryx. To help us to respond to your request we ask that you try to provide the below detail about the bug.

Describe the bug A clear and specific description of what the bug is. What the error, incorrect or unexpected behaviour was.

Expected behaviour
A clear and concise description of what you expected to happen.

Sample Code/Statement
If you can, please submit the SQL statement or Python code snippet, or a representative example using the sample datasets.

SELECT COUNT(*) AS Missions, Company FROM space_missions.parquet GROUP BY Company ORDER BY Missions DESC

SqlError: SELECT statement contains multiple references to the same column, perhaps as aliases or with qualifiers.

Additional context
Add any other context about the problem here.

[joocer]

using a sample dataset:

SELECT COUNT(*) AS planets, id FROM $planets GROUP BY id ORDER BY planets DESC