prql icon indicating copy to clipboard operation
prql copied to clipboard

Resolve * to specific column names

Open aljazerzen opened this issue 2 years ago • 1 comments

I would like this to be possible:

from employees
select [first_name, last_name]
group * ( | aggregate count)

but emit an error on this:

from employees
group * ( | aggregate count)

... because we cannot know what columns there are in employees and SQL does not support * in GROUP BY (I presume).

aljazerzen avatar May 27 '22 15:05 aljazerzen

Yes that would be great.

(FWIW DuckDB can do the latter, but I think that's the only one)

max-sixty avatar May 27 '22 16:05 max-sixty