You can view ... the SQL Server 2016 OPENJSON function. Typical code looks like this: Select * From OPENJSON (jsondata); By default, the resulting table has columns (called key, value and type) with ...

With SQL Server ... function to have the fragment converted to a virtual table, effectively creating a table from a column in the row. You can then join that virtual table to its row using CROSS APPLY ...