Another good use case is report generation that involves audit trailing the details of the report generated. So one could just pull the data from the source and insert the requested report into a new table on the fly. Lots of great use. Came across it recently. I wonder if orm's like prisma rely on this to return data in any form.