Join parent objects with their child entities, for example we want a relational table of each person and their hobbies
DECLARE @json nvarchar(1000) =
N'[
{
"id":1,
"user":{"name":"John"},
"hobbies":[
{...