Not a fan of soft deleting, but as I sit here I wonder if using an RLS policy to limit to anything without a deleted field would make the whole “forgetting a where” a bit easier? I’m not sure the performance would be great though