If only generating pivot tables in SQL were uniformly easy. Postgres's "crosstab" is awkward at best, forcing you to specify column names every time makes explo

If only generating pivot tables in SQL were uniformly easy. Postgres's "crosstab" is awkward at best, forcing you to specify column names every time makes exploration unpleasant. In the end I found it easier to do crosstabulation in the UI (or at least, not in SQL).