title: Populate postgres table with json array + separate variables
body: <p>Consider the table:</p>
  <pre><code>CREATE TABLE watermelon
  (
      order_id integer,
      sort text,
      size integer,
      juiciness integer,
      sender text,
  );
  </code></pre>
  <p>I have an incoming json looking like this:</p>
  <pre><code>{
      &quot;order_id&quot;: 500,
      &quot;items&quot;: [
          {
              &quot;sort&quot;: &quot;regularMidterranian&quot;,
              &quot;size&quot;: 6,
              &quot;juiciness&quot;: 85
          },
          {
              &quot;sort&quot;: &quot;yellowMexican&quot;,
              &quot;size&quot;: 4,
              &quot;juiciness&quot;: 90
          }
      ],
      &quot;sender&quot;: &quot;SantaClara&quot;
  }
  </code></pre>
  <p>Is there a way to neatly insert this json into the table in one query, thus creating 2 entries with all fields filled?</p>
  <p>Or is it simpler to just modify the json beforehand, extracting JArray adding order_id &amp; sender to all items and then using regular json_populate_record?</p>