I have found soft deletes to be really helpful to preserve historical references and as a simple but reversible enable disable switch. Sometimes a really destr

I have found soft deletes to be really helpful to preserve historical references and as a simple but reversible enable disable switch. Sometimes a really destructive delete isn't something you want to do by default. I have seen them abused and a lot of times queries forget to take the flag into account. Every decision is a trade-off.