Do you have plans of supporting PIVOT functions in a future version (or is it already supported and I missed it)?
I found this old post saying that it might be added in a future version:
No, you haven't missed anything.
We are still planning to add support of PIVOT and UNPIVOT in the upcoming major version. Hopefully, it will be ready until the end 2018.