Soft Delete vs Hard Delete: What deleted_at Actually Costs You

You add a deleted_at column so users can delete their accounts without you losing data. A week later, support reports that people who deleted their account can't sign up again: "email already taken."