I just wish you could say “pivot this column” and have the database figure out columns it would generate - we can control exactly which rows are picked and I ha

I just wish you could say “pivot this column” and have the database figure out columns it would generate - we can control exactly which rows are picked and I hate restarting to dynamic sql to fix this