Far as I've seen, anyone who wanted to do this used SQL queries on the database as you mentioned. Though the only use case I've personally seen was just for archiving data from the audit log table so we didn't need to display it in a certain way.
Dave Morris, 3Ci at Southern Company