Capabilities are not checked for insert update delete operations, the original expectation was probably that the connector will throw an exception on an unsupported construct. However most connectors aren't written to properly handle unsupported pushdown sql.