How about adding an upsertOrIgnore method?

[oleksiikhr]

I was faced with a situation where I had to write a query like this:

INSERT IGNORE INTO %raw% ON DUPLICATE KEY UPDATE %raw%

But as it turned out, there are only upsert and insertOrIgnore inside the query builder.

---

Example.

CREATE TABLE parent (
    id INT NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE child (
    parent_id INT NOT NULL,
  	 data INT NOT NULL,
    PRIMARY KEY (parent_id),
    FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE
);

INSERT INTO parent (id) VALUES (1), (2);

INSERT IGNORE INTO child (parent_id, data) VALUES (1, 1), (1, 1), (2, 1), (3, 1) ON DUPLICATE KEY UPDATE `data` = `data` + VALUES(`data`);

And I expect to see:

parent_id	data
1	2
2	1

---

But here's the problem, this method is implemented only for MySQL, in PostgreSQL and SqlServer grammar it will not be supported (in SQLite don't know).

Does anyone have any idea how to write it this way without raw sql? Perhaps you will have some ideas, maybe I missed something.