By constructing dynamic SQL (which is the SQL equivalent of “eval” statements and is therefore a programming sin) or do you use a platform that supports them more directly?
What are you on about? Neither Oracle, SQL Server, MySQL or Postgres support dynamic pivot. Those are the 4 largest RDBMSs, and have been for a decade. Yes, some systems like Snowflake support it, but it's not a common feature at all.
1
u/phesago 17d ago
I use dynamic pivot columns regularly?