[reilly3000]

This article enlightened me on the underlying logic, as well as some different implementations. https://modern-sql.com/use-case/pivot

[nevi-me]

I was lazy to add its link, that's where I learnt about the proprietary implementations of various databases.

I wonder if we'll ever get an ANSI-2019 SQL version that tries to merge what various DB vendors have branched off and done. Maybe it already exists? https://www.whoishostingthis.com/resources/ansi-sql-standard...