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...