I agree, DBs need to solve this better. Temporal tables seems like a step in the right direction but they too add complexity and gotchas. And I think they are

I agree, DBs need to solve this better. Temporal tables seems like a step in the right direction but they too add complexity and gotchas. And I think they are kind of overkill for just softdeletes. Another low level solution are Views. But I have databases approaching a thousand tables. Duplicating 1000 tables as views would add significant friction to development and maintenance.