Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE layout(id int, configurations jsonb);
INSERT INTO layout(id, configurations) VALUES(1, '
   [
      {"data": {"x": 664, "y": 176 }, "layout_id": "1", "layout_name": "Corner"},
      {"data": {"x": 334, "y": 268 }, "layout_id": "2", "layout_name": "Outside"}
   ]
');
1 rows affected

select (select json_agg(case when (v.value -> 'layout_id')::text = '"1"' then v.value::jsonb || '{"layout_name":"Ground Floor1"}'::jsonb else v.value end) from jsonb_array_elements(l.configurations) v) from layout l where l.id = 1


json_agg


[{"data": {"x": 664, "y": 176}, "layout_id": "1", "layout_name": "Ground Floor1"}, {"data": {"x": 334, "y": 268}, "layout_id": "2", "layout_name": "Outside"}]


update layout set configurations = (select json_agg(case when (v.value -> 'layout_id')::text = '"1"' then v.value::jsonb || '{"layout_name":"Ground Floor Edge"}'::jsonb else v.value end) from jsonb_array_elements(layout.configurations) v) where layout.id = 1
1 rows affected

select * from layout


id
configurations


1
[{"data": {"x": 664, "y": 176}, "layout_id": "1", "layout_name": "Ground Floor Edge"}, {"data": {"x": 334, "y": 268}, "layout_id": "2", "layout_name": "Outside"}]