prql
prql copied to clipboard
Resolve * to specific column names
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).
Yes that would be great.
(FWIW DuckDB can do the latter, but I think that's the only one)