is the labkey pivot syntax documented anywhere? i didnt see anything when i search the doc site for 'pivot' and the word pivot doesnt appear in any SQL files in the project.

i know i've seen 2 examples of it, one where the pivot columns were hard-coded and one where they came from a subselect, but i cant seem to find those now.

would it be possible to post it and/or add it to the doc? here's where i'd normally expect it:

https://www.labkey.org/wiki/home/Documentation/page.view?name=labkeySql

thanks.