Select data from json and insert it into single row and multiple column

get_values_as_column_from_json.sql

CREATE TABLE my_table(col text, col2 text)

/* SELECT DATA FROM JSON */
SELECT * FROM json_each('{"a":"foo", "b":"bar"}') AS e
  
/* INSERT INTO TABLE */
INSERT INTO my_table(col, col2) 
SELECT * FROM json_to_record('{"a":"foo", "b":"bar"}') AS x(col text, col2 text) -- as can have different column name

SELECT * FROM my_table

/* UPDATE RECORD IN my_table */
UPDATE my_table
SET col = x.a, col2 = x.b
FROM json_to_record('{"a":"11111", "b":"bar222"}') AS x(a text, b text)
WHERE col='foo'