title: Expand row with an JSON Array inside a Column to multiple rows
body: <p>I encountered a SQL-Data-Migration (SQL Server) problem and i hope, you can guide me in the right direction.</p>
  
  <p>Assume, we have the table <code>DataTable</code> (names simplified) with the following columns:</p>
  
  <pre><code>DataID | SomeForeignKey | SpecificDataValues | OtherSpecificDataValues
  int    | int            | String             | String
  -------+----------------+--------------------+------------------------
  0      | 1              | ['1','2']          | ['1', '2']
  </code></pre>
  
  <p>where <code>SpecificDataValues</code> and <code>OtherSpecificDataValues</code> are JSON arrays (like <code>['1', '2']</code>)</p>
  
  <p>Now i want to migrate this table (with an SQL Migration script at best) to a new table:</p>
  
  <pre><code>DataValuesTable
  DataID | SomeForeignKey | SpecificDataValues | OtherSpecificDataValues
  -------+----------------+--------------------+------------------------
  0      | 1              | 1                  | 1
  1      | 1              | 2                  | 2
  </code></pre>
  
  <p>So, i basically want to generate a new row in a new table for each value, stored in "SpecificDataValues" and "OtherSpecificDataValues"</p>
  
  <p>I already checked, that there are SQL functions to work with JSON (OPENJSON, JSON_QUERY) but i was not able to produce the desired result using this tools.</p>
  
  <p>I hope, you can show me the right direction.</p>