implement grouping sets, cubes, and rollups #1327
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
a challenge to design and implement grouping sets, cubes, and rollups.
Describe the solution you'd like
similar to https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-GROUPING-SETS
Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.
Additional context
this would be a rather large piece of work so ideally can be split up into three subsets:
- update sqlparser parse grouping sets, rollup, and cube for postgresql datafusion-sqlparser-rs#366
- grouping sets
- cubes
- rollups