Subdocument operations

Node.js SDK
4

email object fields are dynamic and you want retrieve them you need to convert into OBJECT_VALUES()
OBJECT_VALUES(x), OBJECT_NAMES(x), OBJECT_PAIRS(x) converts x into array.

SELECT OBJECT_VALUES(e)[0].*
FROM default AS d
UNNEST d.person AS p
UNNEST p.`cc54bfc9-21de-4729-8ebb-b5ffcd6b4851`.email AS e;

OR

 SELECT e1.*
    FROM default AS d
    UNNEST d.person AS p
    UNNEST p.`cc54bfc9-21de-4729-8ebb-b5ffcd6b4851`.email AS e
    UNNEST  OBJECT_VALUES(e) AS e1;

OR

 SELECT ep.name, ep.val.*
    FROM default AS d
    UNNEST d.person AS p
    UNNEST p.`cc54bfc9-21de-4729-8ebb-b5ffcd6b4851`.email AS e
    UNNEST  OBJECT_PAIRS(e) AS ep;