SQL Server 2016 adds new support for the JSON format when ... JSON PATH and enclose your aliases in either single quotes or brackets. The following query creates a nested object called Name by ...

If you have an array of a nested object that you want to extract ... For more information on this feature, see "Format Query Results as JSON with FOR JSON (SQL Server)" in the Microsoft documentation.