With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

Figure 1. A SQL Server query against the Northwind database executed in PowerShell. (Click image to view larger version.) Fig. 2 is that same query as executed in SSMS (yes, I finally did get it to ...