Postgres 15

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

CREATE TABLE

INSERT 0 3

id	body
1	{"skills": [{ "isPrimary": "true", "name": "Node.js" },{ "isPrimary": "false", "name": "Python" },{ "isPrimary": "false", "name": "Javascript" }]}
2	{"skills": [{ "isPrimary": "true", "name": "Mysql" },{ "isPrimary": "false", "name": "Postgres" },{ "isPrimary": "false", "name": "Nest.js" }]}
3	{"skills": [{ "isPrimary": "true", "name": "Qa" },{ "isPrimary": "false", "name": "Mongo" }]}

SELECT 3

UPDATE 3

id	body
1	{"skills": [{"name": "Node.js", "isPrimary": 5}, {"name": "Python", "isPrimary": 1}, {"name": "Javascript", "isPrimary": 1}, {"name": "Mysql", "isPrimary": 5}, {"name": "Postgres", "isPrimary": 1}, {"name": "Nest.js", "isPrimary": 1}, {"name": "Qa", "isPrimary": 5}, {"name": "Mongo", "isPrimary": 1}]}
2	{"skills": [{"name": "Node.js", "isPrimary": 5}, {"name": "Python", "isPrimary": 1}, {"name": "Javascript", "isPrimary": 1}, {"name": "Mysql", "isPrimary": 5}, {"name": "Postgres", "isPrimary": 1}, {"name": "Nest.js", "isPrimary": 1}, {"name": "Qa", "isPrimary": 5}, {"name": "Mongo", "isPrimary": 1}]}
3	{"skills": [{"name": "Node.js", "isPrimary": 5}, {"name": "Python", "isPrimary": 1}, {"name": "Javascript", "isPrimary": 1}, {"name": "Mysql", "isPrimary": 5}, {"name": "Postgres", "isPrimary": 1}, {"name": "Nest.js", "isPrimary": 1}, {"name": "Qa", "isPrimary": 5}, {"name": "Mongo", "isPrimary": 1}]}

SELECT 3