title: Need to flatten json array in azure-cosmos db
body: <p>I have simple JSON </p>
  
  <pre><code>{"ProductUID":1100,"Color":"White","tags":["toy","children","games"]}
  </code></pre>
  
  <p>I want output as </p>
  
  <pre>
  [
      {
          "ProductUID": 1100,
          "Color":"White",
          "tags":"toy"
      },
      {
          "ProductUID": 1100
           "Color" : "White",
           "tags" : "Children"
      },
      {
          "ProductUID": 1100,
          "Color": "White",
          "tags": "games"
      }
  ]
  </pre>
  
  <p>I have tried this query in cosmos db but couldn't separate tags array</p>
  
  <pre><code>SELECT  P.ProductUID, P.tags
  FROM Products P
  join C in P.tags
  </code></pre>