Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select '[
  {
    "name": "abc",
    "ques": [
      {
        "qId": 100
      },
      {
        "qId": 200
      }
    ]
  },{
    "name": "xyz",
    "ques": [
      {
        "qId": 100
      },
      {
        "qId": 300
      }
    ]
  }
]' :: jsonb

jsonb

[{"name": "abc", "ques": [{"qId": 100}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 100}, {"qId": 300}]}]

SELECT 1

CREATE TABLE TABLE_NAME (COLUMN_NAME jsonb) ;
INSERT INTO TABLE_NAME VALUES ('[{"name": "abc", "ques": [{"qId": 100}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 100}, {"qId": 300}]}]' :: jsonb) ;
SELECT * FROM TABLE_NAME ;

CREATE TABLE

INSERT 0 1

column_name

[{"name": "abc", "ques": [{"qId": 100}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 100}, {"qId": 300}]}]

SELECT 1

Update TABLE_NAME 
   set COLUMN_NAME = replace(COLUMN_NAME :: text,'"qId": 100}', '"qId": 101}') :: jsonb ;
SELECT * FROM TABLE_NAME ;

UPDATE 1

column_name

[{"name": "abc", "ques": [{"qId": 101}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 101}, {"qId": 300}]}]

SELECT 1

Update TABLE_NAME 
   set COLUMN_NAME = replace(COLUMN_NAME :: text,'"qId": 101}', '"qId": 100}') :: jsonb ;
SELECT * FROM TABLE_NAME ;

UPDATE 1

column_name

[{"name": "abc", "ques": [{"qId": 100}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 100}, {"qId": 300}]}]

SELECT 1

CREATE OR REPLACE FUNCTION jsonb_set(x jsonb, y jsonb,  path text[], new_value jsonb) RETURNS jsonb LANGUAGE sql AS $$
SELECT jsonb_set(COALESCE(x, y), path, new_value) ; $$ ;

CREATE OR REPLACE AGGREGATE jsonb_set_agg(x jsonb, path text[], new_value jsonb)
( stype = jsonb, sfunc = jsonb_set);

CREATE FUNCTION

CREATE AGGREGATE

UPDATE TABLE_NAME 
   set COLUMN_NAME = 
(SELECT jsonb_set_agg('[{"name": "abc", "ques": [{"qId": 100}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 100}, {"qId": 300}]}]' :: jsonb, array[(a.id - 1) :: text, 'ques', (b.id - 1) :: text], jsonb_build_object('qId', 101))
  FROM jsonb_path_query('[{"name": "abc", "ques": [{"qId": 100}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 100}, {"qId": 300}]}]' :: jsonb, '$[*]') WITH ORDINALITY AS a(content, id)
  CROSS JOIN LATERAL jsonb_path_query(a.content->'ques', '$[*]') WITH ORDINALITY AS b(content, id)
  WHERE (b.content)->'qId' = to_jsonb(100)) ;
SELECT * FROM TABLE_NAME ;

UPDATE 1

column_name

[{"name": "abc", "ques": [{"qId": 101}, {"qId": 200}]}, {"name": "xyz", "ques": [{"qId": 101}, {"qId": 300}]}]

SELECT 1