I would like to write a query like
delete from inventory_reservation where JSON_EXTRACT(metadata, '$.object_increment_id') = '<increment_id>'
So I created my expression in my code like
$expression = "JSON_EXTRACT(metadata,'$.object_increment_id') = ?";
And then I try to invoke a delete action like this
$this->resourceConnection->getConnection()->delete($table, [$expression, $order->getIncrementId()]);
However the resulting query is this one
DELETE FROM `inventory_reservation` WHERE (JSON_EXTRACT(metadata,'$.object_increment_id') = ?) AND (5000447466)`
It’s not performing a replace on the parameterized query. What am I doing wrong here?