Jovan Popvic introduces us to the WITHOUT_ARRAY_WRAPPER clause:
This option enables you to remove square brackets [ and ] that surround JSON text generated by FOR JSON clause. I will use the following example:
SELECT 2015 as year, 12 as month, 15 as day FOR JSON PATH, WITHOUT_ARRAY_WRAPPERThis query will return:
{ "year":2015, "month":12, "day":15 }However, without this option, following text would be returned:
[{ "year":2015, "month":12, "day":15 }]
Jovan also points out important changes between 3.1 and 3.2 with FOR JSON output.