implement grouping sets, cubes, and rollups

[jimexist]

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

[jimexist]

I guess a modification to sqlparser is also needed?

update: apache/datafusion-sqlparser-rs#366

[alamb]

FYI @thinkharderdev bashed this out in #2716 🥇