text: INSERT INTO films VALUES ('UA502', 'Bananas', 105, '1971-07-13', 'Comedy', '82 minutes')
  
  INSERT INTO films (code, title, did, date_prod, kind) VALUES
      ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
      ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy')
  
  INSERT INTO films DEFAULT VALUES
  
  INSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07'
  
  INSERT INTO distributors ("Did", dname) VALUES (DEFAULT, 'XYZ Widgets')
     RETURNING "Did", changed
  
  INSERT INTO tictactoe (game, board[1:3][1:3])
      VALUES (1, '{{" "," "," "},{" "," "," "},{" "," "," "}}')
  
  WITH upd AS (
    UPDATE employees SET sales_count = sales_count + 1 WHERE id =
      (SELECT sales_person FROM accounts WHERE name = 'Acme Corporation')
      RETURNING *
  )
  INSERT INTO employees_log SELECT *, current_timestamp FROM upd
  
  INSERT INTO distributors (did, dname) VALUES (7, 'Redline GmbH')
      ON CONFLICT (did) DO NOTHING
  
  INSERT INTO distributors (did, dname) VALUES (9, 'Antwerp Design')
      ON CONFLICT ON CONSTRAINT distributors_pkey DO NOTHING
  
  INSERT INTO distributors (did, dname)
      VALUES (5, 'Gizmo Transglobal'), (6, 'Associated Computing, Inc')
      ON CONFLICT (did) DO UPDATE SET dname = EXCLUDED.dname
  
  INSERT INTO distributors AS d (did, dname) VALUES (8, 'Anvil Distribution')
      ON CONFLICT (did) DO UPDATE
      SET dname = EXCLUDED.dname || ' (formerly ' || d.dname || ')'
      WHERE d.zipcode <> '21201'
  
  INSERT INTO distributors (did, dname) VALUES (10, 'Conrad International')
      ON CONFLICT (did) WHERE is_active DO NOTHING
  