In this section, you’ll see examples of complex modeling via nesting, object references, and arrays. JSON with nested objects. Listing 4 shows how to define nested JSON objects. Listing 4 ...

With FOR JSON AUTO you can also retrieve rows from related tables and those related tables will appear as nested objects. This SQL statement, for example, joins the Customer and SalesOrder table: ...

If an object happens to have more nested object within it, it will only parse down to the desired depth. As we have already covered some of the output with ConvertTo-JSON in my previous example, I ...