Support soft deletes

Soft deletes are commonplace in many data scenarios. This can be done with Coalesce, but the build in functionality for deletes does an actual delete.
It would be nice to be able to mark a class as using soft deletes which might expose functionality for this automatically.
This could either replace the existing delete functionality or replace it and add a permanent delete as well.