[FEATURE] PIVOT functions

[joocer]

trafficstars

Although PIVOT looks like a nightmare to use, so may not implement as it's unlikely the skill to use it is prevalent in the existing user community.

https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver16

[joocer]

This should probably be written using CASE, nested functions and Jinja templating