I like to use crosstab to pivot a long list of rows into columns, however the column labels are created dynamically with the resulting column type known.
Is there a way pass a list of names and types to crosstab (‘query’) as (<‘type list as strings in array’> ) ?