You are kind of playing with fire if you go down that path, you are likely to miss records in all sorts of auditing tables and clearly bypass lots of validations in code.
Yeah and I’m not going the SQL route. Sometimes when you are faced with a problem, a more creative approach to the problem is more elegant than your original design, and that’s how I’m structuring my archives.
But I am impressed with the data structure Discourse is using, and my congratulations to the data design team.