Also, the "JSON Support in SQL Server 2016" Redgate Community article provides a more business-oriented view of JSON in SQL Server 2016, along with a scenario-based perspective of the use of JSON data ...

Querying JSON Data in SQL Server 2016. With SQL Server 2016, it now makes sense to store JSON objects in your database ... This query uses it in both the Order By and Where clauses, for example: ...