How can i access (query) Object in Array of another Object Array

SQL++
18

posted over here Subdocument operations

SELECT  pp.name AS pid , ep.name AS eid, ep.val.*
    FROM default AS d
    UNNEST d.person AS p
     UNNEST OBJECT_PAIRS(p) AS pp
    UNNEST pp.val.email AS e
    UNNEST  OBJECT_PAIRS(e) AS ep;