With SQL Server 2016, it now makes sense to store JSON objects in your database ... the value of the SignupDate property and $.Name.First would retrieve "Peter" from the First property of the Name ...

SQL Server supports that, too … including updating those object’s properties once you retrieve them. Working with Arrays For example, you might have an array of JSON stored in an NVarChar column, ...