DeleteWithFilter command performs set-based deletes using a where expression or filter object.
This accepts a SQL expression, with optional parameter object, or a filter object.
If soft delete is enabled for this table, an update operation will be generated to set the deleted flag.
Implementation of the delete varies by database.
SQL Server uses an UPDATE statement with an optional OUTPUT clause.
SQLite uses a separate DELETE and optional SELECT statement.