[Feature Request]: Delete transform - show evidence of deleted rows

### What would you like to happen?

The Delete transform does its job, it deletes rows from a table based on the specified criteria, however it shows no evidence in the (Basic) log of what has been done: at least the total number of deleted rows can be useful.

The numbers shown in the Basic log refer to the rows that are traversing the transform (i.e. the searched keys for the deletion of records), and not to the rows that are actually deleted from the database.

### Issue Priority

Priority: 3

### Issue Component

Component: Transforms

Start by locating the Delete transform and its Basic log implementation in the Hop codebase, then inspect how database deletion results are currently handled. The work is done when the Basic log reports the total number of rows actually deleted, distinct from the rows traversing the transform; add or update focused tests for that behavior if the existing transform tests identify a suitable location.

Written by the indexing model from the issue text.