Recursive Cartesian Product for Generating Column Names in SQL

Unpivoting a Query in Presto to Get Column Names Based on Condition

How to Dynamically Generate Column Names for Pivoted Tables in SQL

How to Create a Pivot Table in Oracle SQL Without Using Aggregate Functions