Insert or ignore ability

[absolux]

API suggestion

// SQLite compatible
qb.insert(data).into(table, ...columns).orIgnore()

// or

// PostgreSQL compatible
qb.insert(data).into(table, ...columns).onConflict('key').ignore()

[absolux]

-- SQLite
insert or ignore into target (a, b) values (?, ?)

-- MySQL
insert ignore into target (a, b) values (?, ?)

-- PostgreSQL
insert into target (a, b) values($1, $2) on conflict (a) do nothing

-- MSSQL
insert into target(a, b)
select * from (values(?, ?)) as t(a, b)
where not exists (select * from target where target.a = t.a)
-- or using merge
merge into target
using (values(?)) as t(a) on (target.a = t.a)
when not matched then insert (a, b) values(?, ?)