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?
