JSON对象查询SQL服务器

我有一个JSON字符串，如下所示:

[
    {
        "id": 103001058774,
        "name": "status",
        "label": "Status",
        "description": "Ticket status",
        "choices": {
            "2": [
                "Open",
                "Open"
            ],
            "3": [
                "Pending",
                "Pending"
            ],
            "4": [
                "Resolved",
                "Resolved"
            ],
            "5": [
                "Closed",
                "Closed"
            ],
            "6": [
                "Waiting on Customer",
                "Awaiting your Reply"
            ],
            "7": [
                "Waiting on Third Party",
                "Being Processed"
            ],
            "8": [
                "Assigned",
                "Assigned"
            ]
        }
    }
]

我正在try 将其放入JSON的CHOICES部分中的如下所示的SQL表中:

我已经有了这个问题，我是在正确的线上…但我不知道怎么go 掉身份证号码！:

DECLARE @jsonStatusesData NVARCHAR (MAX) = *'My JSON String'*

SELECT id = JSON_QUERY(j.value, $.choices')
FROM OPENJSON(@jsonStatusesData) AS j

我确实还有几行代码需要添加，但最终上面的表格才是我想要做的.当然，该SQL查询只是返回整个Choices分支，对我没有任何帮助.

任何帮助都是最好的！:)

谢谢,

灰烬