Dealing with a separate table is still hard (I know because we do this). What happens when you do a migration or need to shard something and want consistent par

Dealing with a separate table is still hard (I know because we do this). What happens when you do a migration or need to shard something and want consistent partitioning across your data? You have to consider your one off table that everyone inevitably forgets about. I agree that a deleted_at column is too big of a liability for compliance reasons though