Is your feature request related to a problem? Please describe.
Often I want to produce a table which is a bi-product of an existing table. The new table being a pivot of the original one, where I define a column (of type symbol) an index (of type timestamp) a value (anything) and some aggregation function (last / first / mean, etc).

Describe the solution you'd like
Ability to PIVOT inside QDB would be very useful (as described above).

Describe alternatives you've considered
Currently I can't do this in QDB directly so I end up getting the original table and pivoting locally (in my case via python - pandas).

Additional context
None.