Soft deletion probably isn’t worth it

Why SQL’s ‘deleted_at’ columns are a net negative, and what to do instead.