Soft Delete field type

[blalan05]

Is your feature request related to a problem? Please describe.
A common DB ORM feature is the ability to have a deletedAt date column that gets updated with deleting, so the row isn't actually deleted, but there is a simply way to not return deleted with a flag.

Describe the solution you'd like
Add deletedAt field type (similar to createdAt and updatedAt), that is controlled by API if softDelete (or paranoid) flag on entity. If softDelete (or paranoid) flag on Entity, then { where: { deletedAt: null } } filter should be automatically added in find

Describe alternatives you've considered
All this could be done in userland with a lot of boilerplate.

Additional context
Elequent ORM example
Sequelize example