在SurrealDB中使用SurrealQL访问多层嵌套对象异常问题

我在SurrealDB中通过记录链接将数据分散存储在Show、Event、Competitions、Arena四张表中，数据关系为：

• 每个Show包含多个Event
• 每个Event包含多个Competitions
• 每个Competitions对应一个Arena

预期的数据结构如下：

show {
  events [{
    competitions [{
      arena {
        name
      }
    }]
  }]
}

但使用SurrealQL的点符号查询时，返回结果里每个赛事对应的arena变成了嵌套数组，而非预期的结构化数据。我尝试了event.competitions.arena.name和event.*.competitions.*.arena.name两种写法，结果完全一致。

预期输出 #

[
    {
        "events": [
            {
               "competitions": [
                    {
                        "arena": {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        }
                    },
                    {
                        "arena": {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        }
                    }
                ],
                "competitions": [
                    {
                        "arena": {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        }
                    },
                    {
                        "arena": {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        }
                    },
                    {
                        "arena": {
                            "id": "arena:tyv124",
                            "name": "Arena 2"
                        }
                    }
                ]
            }
        ]
    }
]

实际输出 #

[
    {
        "events": {
            "competitions": {
                "arena": [
                    [
                        {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        },
                        {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        }
                    ],
                    [
                        {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        },
                        {
                            "id": "arena:tyv123",
                            "name": "Arena 1"
                        },
                        {
                            "id": "arena:tyv124",
                            "name": "Arena 2"
                        }
                    ]
                ]
            }
        }
    }
]

内容的提问来源于stack exchange，提问作者Andross