CODE EXAMPLE FOR SQL

postgresql sql insert into select from values

INSERT INTO target(c1, c2)
SELECT source.c1, source.c2
FROM (VALUES
          ('a', 1),
          ('b', 2)
     ) AS source(c1, c2);