But... this query used

    UPDATE orders
    SET is_deleted = true

DELETE without WHERE wasn't part of the problem.