Does anyone have some code that I can blatantly steal to perform an excel-esque "pivot" on a query? This is for MariaDb / mySql - so unlike msSQL - there isn't a DBMS pivot() function that I can utilise. Saying that I would much rather it be in CFML than reply on a database dialect, anyway.

This may point you in the right direction: https://www.databasestar.com/mysql-pivot/. It depends on your source data and what the end result should be.