SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable2 
(
    jsondata nvarchar(max)
)

INSERT INTO mytable2
VALUES ('
{
    "name": "Daily06012023",
    "documents": [
    {
            "imageUrl": "s3://2023/129/2312908000.tif",
            "json": {
                "indexingRecordId": "2312908000",
                "instrumentNumber": "2312908000"
                              
        }
        },
        {
            "imageUrl": "s3://2023/129/2312908000.tif",
            "json": {
                "indexingRecordId": "2312908001",
                "instrumentNumber": "2312908001"
                              
        }
        },
        {
            "imageUrl": "s3://2023/129/2312908000.tif",
            "json": {
                "indexingRecordId": "2312908002",
                "instrumentNumber": "2312908002"
                              
        }
        },
        {
            "imageUrl": "s3://2023/129/2312908000.tif",
            "json": {
                "indexingRecordId": "2312908003",
                "instrumentNumber": "2312908003"
                              
        }
        }
    ]

}      
'      
)

1 rows affected

jsondata
{ "name": "Daily06012023", "documents": [ { "imageUrl": "s3://2023/129/2312908000.tif", "json": { "indexingRecordId": "2312908000", "instrumentNumber": "2312908000" } }, { "imageUrl": "s3://2023/129/2312908000.tif", "json": { "indexingRecordId": "2312908001", "instrumentNumber": "2312908001" } }, { "imageUrl": "s3://2023/129/2312908000.tif", "json": { "indexingRecordId": "2312908002", "instrumentNumber": "2312908002" } }, { "imageUrl": "s3:\/\/NEW_Path\/2312908003.tif", "json": { "indexingRecordId": "2312908003", "instrumentNumber": "2312908003" } } ] }

jsondata

{
"name": "Daily06012023",
"documents": [
{
"imageUrl": "s3://2023/129/2312908000.tif",
"json": {
"indexingRecordId": "2312908000",
"instrumentNumber": "2312908000"

}
},
{
"imageUrl": "s3://2023/129/2312908000.tif",
"json": {
"indexingRecordId": "2312908001",
"instrumentNumber": "2312908001"

}
},
{
"imageUrl": "s3://2023/129/2312908000.tif",
"json": {
"indexingRecordId": "2312908002",
"instrumentNumber": "2312908002"

}
},
{
"imageUrl": "s3:\/\/NEW_Path\/2312908003.tif",
"json": {
"indexingRecordId": "2312908003",
"instrumentNumber": "2312908003"

}
}
]

}