SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.