title: Transact SQL union all on json results escaping nested json queries
body: <p>I am having a problem with union operation on json results as for some reason my nested json queries results get their double quotes escaped which causes parse errors in my application. Here Is the example:</p>
  
  <pre><code>SELECT DISTINCT s.*,
  JSON_QUERY((select * from SomeTable WHERE Id = 'some ID' FOR JSON PATH, WITHOUT_ARRAY_WRAPPER)) AS ExampleColumn from [SomeOtherTable] sot where sot.Id = 'some other ID' 
  UNION ALL
  SELECT DISTINCT S1.*, JSON_QUERY((select * from SomeTable WHERE Id = 'some other other ID' FOR JSON PATH, WITHOUT_ARRAY_WRAPPER)) AS ExampleColumn from [SomeOtherTable] sot1 where sot1.Id = 'some other other other ID' FOR JSON PATH
  </code></pre>
  
  <p>The result is correct, only the nested JSON_QUERY results have escaped double quotes. Can anyone help me please?</p>