PIVOT operation in DruidSQL

Hello Everyone, Is it possible to apply pivot operation using DruidSQL? I cannot see those functions available in DruidSQL and many of the aggregations like first, last functions are also not available. Is these operations are possible?

Thanks

Hello everyone, any Idea on this. It would be more helpful for us.

Thanks