Delete

DELETE dataToDelete FROM targetProvider

The syntax for Insert is optimized for bulk data sets and takes source data set from a previous statement.

The updated data needs to contain the correct unique identifiers and have source fields aliased to the appropriate target fields.