JQJSON将键转换为对象

我正在try 将一个大的JSON从Excel到JSON的转换重新格式化为一个有效的JSON以供导入. 在我的研究中，我遇到了jq，希望有更深入的人可以帮助我.

我有一大群像这样的员工

{
  "Employees": [
    {
      "firstName": "First",
      "lastName": "Last",
      "birthday": "1990-01-01",
      "account": "true",
      "address.street": "Street",
      "address.addition": "1",
      "address.zipCode": "1000",
      "address.city": "Vienna",
      "address.region": "AT",
      "contactDetails.1.phone": "+431234567",
      "contactDetails.1.mail": "first.last@mail.com",
      "organisations.0.id": 1,
      "departments.0.id": 1,
      "roles.0.id": 1
    },
  ]
}

每个员工的输出应如下所示

{
  "Employees": [
    {
      "firstName": "First",
      "lastName": "Last",
      "birthday": "1990-01-01",
      "account": "true",
      "address": {
        "street": "Street",
        "addition": "1",
        "zipCode": "1000",
        "city": "Vienna",
        "region": "AT"
      },
      "contactDetails": [
        {
          "phone": "",
          "mail": ""
        },
        {
          "phone": "+431234567",
          "mail": "first.last@mail.com"
        }
      ],
      "organisations": [
        {
          "id": 1
        }
      ],
      "departments": [
        {
          "id": 1
        }
      ],
      "roles": [
        {
          "id": 1
        }
      ]
    }
  ]
}

JQ有可能做到这一点吗？或者有什么 idea 可以实现这一点吗？