Currently we only use native UPSERT support from postgres in the result backend. Sqlite also supports UPSERT. Quoting the docs
UPSERT in SQLite follows the syntax established by PostgreSQL, with generalizations.
We should see if we can use native UPSERT from sqlite rather than the DELETE + INSERT fallback logic.
Currently we only use native UPSERT support from postgres in the result backend. Sqlite also supports UPSERT. Quoting the docs
We should see if we can use native UPSERT from sqlite rather than the DELETE + INSERT fallback logic.