Insert in the Nest using N1-QL

SQL++
1

All, I want to add the list of rows in the nest.

Existing Document
[
{
“optima_contact”: {
“addressAssocs”: [
{
“activeDate”: “2020-08-17T16:07:41.025Z”,
“addressId”: xyzedga,
“ownershipStatus”: 1,
“srvAddressStatus”: 1
}
],
“externalIds”: [
{
“externalId”: “1234567”,
“externalIdType”: “abc”,
“individualExternalId”: “dagagagwggag”
}
],
“firstName”: “anonymous”,
“id”: “individual_2_123456”,
“individualId”: 123456,
“Roles”: [
{
“createdBy”: “user”,
“individualRoleId”: 999649,
“isDefault”: true,
“relevantEntityId”: “111112254”,
“roleSpecId”: -1,
“statusId”: 1
}
],
“lastName”: “anonymous”,
“statusId”: 27,
“statusLastChangedDate”: “2020-08-17T16:07:43.068Z”,
“tenantId”: “2”,
“type”: “individual”
}
}
]

New Document : Added the rows in the Roles nest

[
{
“optima_contact”: {
“addressAssocs”: [
{
“activeDate”: “2020-08-17T16:07:41.025Z”,
“addressId”: xyzedga,
“ownershipStatus”: 1,
“srvAddressStatus”: 1
}
],
“externalIds”: [
{
“externalId”: “1234567”,
“externalIdType”: “abc”,
“individualExternalId”: “dagagagwggag”
}
],
“firstName”: “anonymous”,
“id”: “individual_2_123456”,
“individualId”: 123456,
“Roles”: [
{
“createdBy”: “user”,
“individualRoleId”: 999649,
“isDefault”: true,
“relevantEntityId”: “111112254”,
“roleSpecId”: -1,
“statusId”: 1
},
{
“createdBy”: “agent”,
“individualRoleId”: 999650,
“isDefault”: false,
“parentAccountInternalId”: “111122222”,
“relevantEntityId”: “1213414:0”,
“roleSpecId”: -3,
“statusId”: 1
}
],
“lastName”: “anonymous”,
“statusId”: 27,
“statusLastChangedDate”: “2020-08-17T16:07:43.068Z”,
“tenantId”: “2”,
“type”: “individual”
}
}
]

Need to prepare the n1ql query to add the nesting in the document.

2 
UPDATE optima_contact AS oc
SET   oc.Roles = ARRAY_APPEND(oc.Roles, {..............})
WHERE type = "individual";