title: Why SQL returns an Array instead of an Object?
body: <p>I'm using SQL SERVER 2016 JSON result, but I don't know why it converts everything to array, e.g. if I execute the following query it returns an array instead of an object:</p>
  
  <pre><code>SELECT 1 AS One,2 AS Two,3 AS Three
  FOR JSON PATH
  </code></pre>
  
  <p>The result is:</p>
  
  <pre><code>[{"One":1,"Two":2,"Three":3}]
  </code></pre>
  
  <p>But I would like it to return:</p>
  
  <pre><code>{"One":1,"Two":2,"Three":3}
  </code></pre>
  
  <p>Also I tested this query, but the result was the same, again an array:</p>
  
  <pre><code>SELECT TOP 1 1 AS One,2 AS Two,3 AS Three
  FOR JSON PATH
  </code></pre>