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"}}]

}