"Pivot-by/this" 🐇
Explicit pivoting should be a first class feature in all SQL tools, right up there with group-by. Check out these quick video demos below.
More visual SQL tools need explicit "pivot-by-this" functionality. Pivot is always dope.
— Ryan Robitaille (@ryrobes) October 22, 2023
Bonus points: Pivoting by *another SQL query* - works regardless of DB platform (gets pre-processed and translated into a CASE stmt) - thus retains all the composability of reg queries. pic.twitter.com/fAULqJ19RQ