title: Split JSON "dictonary" into separate rows
body: <p>colleagues.
  I have a table like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th style="text-align: center;">param1</th>
  <th style="text-align: center;">param2</th>
  <th style="text-align: center;">config</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">456</td>
  <td style="text-align: center;">789</td>
  <td style="text-align: center;"><code>{&quot;confToUse&quot;: &quot;b&quot;, &quot;configs&quot;: {&quot;a&quot;: { &quot;qwe&quot;: &quot;rty&quot; }, &quot;b&quot;: { &quot;asd&quot;, &quot;fgh&quot; } } }</code></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Small explanation: configurations live in a json 'dictionary' property <code>configs</code>, <code>configToUse</code> property points on config with this key to use.</p>
  <p>My goal is to get new table where each row is a separate configuration:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th style="text-align: center;">name</th>
  <th style="text-align: center;">config</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">x_uniq</td>
  <td style="text-align: center;">a</td>
  <td style="text-align: center;"><code>{ &quot;qwe&quot;: &quot;rty&quot; }</code></td>
  </tr>
  <tr>
  <td style="text-align: center;">y_uniq</td>
  <td style="text-align: center;">b</td>
  <td style="text-align: center;"><code>{ &quot;asd&quot;, &quot;fgh&quot; }</code></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Ideally the result looks like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th style="text-align: center;">param1</th>
  <th style="text-align: center;">param2</th>
  <th style="text-align: center;">use</th>
  <th style="text-align: center;">name</th>
  <th style="text-align: center;">config</th>
  <th style="text-align: center;">use_id</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">x_uniq</td>
  <td style="text-align: center;">456</td>
  <td style="text-align: center;">789</td>
  <td style="text-align: center;">b</td>
  <td style="text-align: center;">a</td>
  <td style="text-align: center;"><code>{ &quot;qwe&quot;: &quot;rty&quot; }</code></td>
  <td style="text-align: center;">y_uniq?</td>
  </tr>
  <tr>
  <td style="text-align: center;">y_uniq</td>
  <td style="text-align: center;">456</td>
  <td style="text-align: center;">789</td>
  <td style="text-align: center;">b</td>
  <td style="text-align: center;">b</td>
  <td style="text-align: center;"><code>{ &quot;asd&quot;, &quot;fgh&quot; }</code></td>
  <td style="text-align: center;">y_uniq?</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>For mysql version reason I can't use JSON_TABBLE. Only JSON_EXTRACT or so.</p>
  <p>At this point could only do this:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT 
      JSON_EXTRACT(tbl.config, &quot;$.configToUse&quot;),
      JSON_EXTRACT(tbl.config, &quot;$.configs&quot;) -- I think there has to be some SELECT
  FROM 
      configs_table tbl
  WHERE
      tbl.id = 123
  ;
  </code></pre>
  <p>and get:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">xxx</th>
  <th style="text-align: center;">yyy</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">b</td>
  <td style="text-align: center;"><code>{&quot;a&quot;: { &quot;qwe&quot;: &quot;rty&quot; }, &quot;b&quot;: { &quot;asd&quot;, &quot;fgh&quot; } }</code></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Please, give me some way to move.</p>