Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
begin;
Create temp table a1 (id bigint, data jsonb);
insert into a1(data) values (
'{"playersContainer": {
"players": [
    {
        "id": "1",
        "name": "Nick",
        "teamName": "Shire Soldiers",
        "ratings": [
            1,
            5,
            6,
            9
        ],
        "assists": 17,
        "manOfTheMatches": 20,
        "cleanSheets": 1,
        "data": [
            3,
            2,
            3,
            5,
            6
        ],
        "totalGoals": 19
    }
  ]
}}'::jsonb);
commit;
1 rows affected

table a1;


id
data


null
{"playersContainer": {"players": [{"id": "1", "data": [3, 2, 3, 5, 6], "name": "Nick", "assists": 17, "ratings": [1, 5, 6, 9], "teamName": "Shire Soldiers", "totalGoals": 19, "cleanSheets": 1, "manOfTheMatches": 20}]}}


update a1 set data =
    data #- '{playersContainer,players,0,ratings,0}'
where (
select  (data['playersContainer']['players'])[0]['id'] ? '1' from a1)
    is true returning *;


id
data


null
{"playersContainer": {"players": [{"id": "1", "data": [3, 2, 3, 5, 6], "name": "Nick", "assists": 17, "ratings": [5, 6, 9], "teamName": "Shire Soldiers", "totalGoals": 19, "cleanSheets": 1, "manOfTheMatches": 20}]}}