If you have an array of a nested object that you want to extract, then you must resort to the ... However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a ...