{
"id": "WakefieldFamily","parents": [
    { "familyName": "Wakefield","givenName": "Robin" },{ "familyName": "Miller","givenName": "Ben" }
],"children": [
    {
        "familyName": "Merriam","givenName": "Jesse","gender": "female","grade": 1,"pets": [
            { "givenName": "Goofy" },{ "givenName": "Shadow" }
        ]
    },{ 
      "familyName": "Miller","givenName": "Lisa","grade": 8 
    }
],"address": { "state": "NY","county": "Manhattan","city": "NY" },"isRegistered": false

};

宠物给孩子的名字叫做“傻瓜”,我怎么查询？

看来下面的语法无效

Select * from root r
WHERE r.children.pets.givenName="Goofy"

相反,我需要做

Select * from root r
WHERE r.children[0].pets[0].givenName="Goofy"

这不是真正通过数组搜索.

任何关于如何处理这些查询的建议？