That soft delete is the next evolution you learn after learning not to issue SQL DELETE instead. But after that it would be more like event sourcing where an ev

That soft delete is the next evolution you learn after learning not to issue SQL DELETE instead. But after that it would be more like event sourcing where an event to delete was issued. And then some sort of snapshot creator would translate that to it's current dataset/view as not being in the data. The event source can always be replayed to see the data at any point in time, including recreating stuff.