Hi all, We are using expose and working with postg...

# server

[alon shoshani.86]

Hi all,
We are using expose and working with postgres,
I found that if I want to make more complex queries I need to write pure mysql.
For example:

INSERT INTO the_table (id, column_1, column_2) 
VALUES (1, 'A', 'X'), (2, 'B', 'Y'), (3, 'C', 'Z')
ON CONFLICT (id) DO UPDATE 
  SET column_1 = excluded.column_1, 
      column_2 = excluded.column_2;

what is the best solution to make such call? and how can be implemeted with prepared statement?