Change Data Capture tracking deletes from SQL Server does not work with Delta sink

Hi,
I am testing the new [change data capture](https://learn.microsoft.com/en-us/azure/data-factory/concepts-change-data-capture) feature. It seems that when rows are deleted from my Azure SQL Server source, they are not deleted from the destination delta table, but instead, the row is appended again. I appreciate you may not want to run an actual DELETE operation on the delta table due to the associated overhead, but I would at least expect a boolean _soft-deleted_ flag so we know how to treat this downstream.
Hope that makes sense.

edit: to clarify I am using the Change Data Capture resource rather than the mapping data flow.

update: this issue also occurs with a flat file destination