I'm facing the same issue as you do, and apart from the Pyspark way (specifiying a `.groupBy(cols,...).pivot(col)`) and putting it in a view to query from SQL, I didn't find a convenient Spark SQL way of doing it.

Is there any plan to add a feature to get dynamic columns in SQL for Pivot on the Databricks side?