Split nested JSON

[D.Demarest]

I have a field named "ModifiedProperties" and it has values like this below, I cant for the life of me figure out how XQL splits these up, Splunk uses SPAN or MVexpand and it works like a champ but i cant figure out what function does the same thing in XQL.  THANK YOU! 

[

  {

    "Name": "StrongAuthenticationRequirement",

    "NewValue": "[]",

    "OldValue": "[\r\n  {\r\n    \"RelyingParty\": \"*\",\r\n    \"State\": 0,\r\n    \"RememberDevicesNotIssuedBefore\": \"2017-10-13T16:59:21+00:00\",\r\n    \"ConfigStore\": null\r\n  }\r\n]"

  },

  {

    "Name": "Included Updated Properties",

    "NewValue": "StrongAuthenticationRequirement",

    "OldValue": ""

  },

  {

    "Name": "TargetId.UserType",

    "NewValue": "Member",

    "OldValue": ""

  }

]