Hacker News new | ask | show | jobs
by mr_toad 1878 days ago
> There are some SQL dialects which provide pivot functions like in pandas, but they are not universal.

And you need to define the columns in advance anyway, because query planners can’t handle columns that change at runtime.