Incorrect behavior using CDC on tap with hard_delete: true

[dluo-sig]

I'm using replication-method: LOG_BASED in the default wintersrd variant of tap-mssql. When hard_delete is true, all records in the snowflake table are deleted before inserting new records (if any). When hard_delete is false, the behavior is as expected and nothing is deleted. New records are inserted and deleted records have _SDC_LSN_DELETED_AT set.

I would expect that hard_delete just deletes these records instead of setting _SDC_LSN_DELETED_AT, with all other behavior remaining the same. It should NOT wipe existing records.