crud operations using json_to_recordset

ddl.sql

CREATE TABLE _table (
  pk SERIAL PRIMARY KEY,
  field1 TEXT,
  field2 TEXT,
  date_deleted TIMESTAMPTZ
);

service.js

client.query(`
  UPDATE _table orig SET
    field1 = r.field1,
    field2 = r.field2
  FROM JSON_TO_RECORD($1) AS r(
    pk int,
    field1 text,
    field2 text
  )
  WHERE orig.pk = r.pk
`, [record])


client.query(`
  INSERT INTO _table (field1, field2)
  SELECT r.field1, r.field2
  FROM JSON_TO_RECORD($1)
`, [record])


client.query(`
  UPDATE _table orig 
  SET date_deleted = NOW()
  WHERE $1
`, [pk])