The JDBC sink connector currently only supports deletion if the connector configuration has set the primary.key.mode to record_key.

There's not an immediately obvious reason why we shouldn't be able to support deletion with record_value (with optional primary.key.fields set) or record_header.