title: Mule3 insert data into 2 tables in a query
body: <p>I have a payload similar to the below sample</p>
  <pre><code>{&quot;timezone&quot;: null,
    &quot;recurrence&quot;: null,
    &quot;event_id&quot;: &quot;55bfe76n3&quot;,
    &quot;attendeesEmail&quot;: [
      {
        &quot;email&quot;: &quot;abc@xyz.com&quot;,
        &quot;responseStatus&quot;: &quot;needsAction&quot;
      },
      {
        &quot;email&quot;: &quot;efg@xyz.com&quot;,
        &quot;responseStatus&quot;: &quot;needsAction&quot;
      }]
  }
  </code></pre>
  <p><strong>I would want to insert the payload into two tables, table A with values in attendeesEmail object and table B having remaining key values. I am looking to have a single db connector to do this operation.</strong></p>
  <p>Things I have tried:</p>
  <p>Using bulk operation to insert but unable to do multiple inserts in a single query inside 1 dbConnector</p>
  <pre><code>BEGIN;
  INSERT INTO A (event_id) values ('55bfe76n3');
  INSERT INTO B (email) values ('abc@xyz.com');
  COMMIT;
  </code></pre>
  <p>This throws an error saying: &quot;<strong>Query type must be one of '[INSERT, STORE_PROCEDURE_CALL]' but was 'DDL' (java.lang.IllegalArgumentException)</strong>.&quot;</p>