I rarely do a D in prod. I've built a generic trigger function for postgres and proc for sql server that will do the auditing in K-V format on every table. And

I rarely do a D in prod. I've built a generic trigger function for postgres and proc for sql server that will do the auditing in K-V format on every table. And I call a proc to add the stuff to the table to create the audit tables and triggers. Works well. I also capture information like the host and session references in an audit batch record that points to the audit detail. I also employ the insert only table for some very special datasets where looking up the history in a quick manner is important.