Native Pivot Operations in Charts

Love the AlaSQL "Query JSON with SQL" function - this solves a lot of problems and makes Retool way more dynamic. However, the pivot operation performed here only works properly 1 time out of 5. If there were a way to toggle a pivot (as opposed to making a transformer), Retool would be a shoo-in for those migrating away from Google sheets, Chartio - going out of service in march, PowerBi, Tableau, and other charting tools