Postgres still doesn't have upsert either. Neither does sql server or Oracle. I hardly see that as a knock against SQLite. All of the above have various levels of hackey workaround so for this though.