Using SQL Server to manipulate JSON data structures, including a boolean gotcha

The problem I was solving I recently did some work to update the structure of some JSON stored in a SQL Server database. The JSON started out as a flat list of properties, and I wanted to add some structure by moving the properties into nested JSON o...