Many database engines implement on-conflict clause mechanism, with various syntaxes and algorithms.
In SQLite, such clause also exists. In particular, the INSERT/UPDATE OR IGNORE and INSERT/UPDATE OR REPLACE
can serve as syntatic sugar for things like ‘insert without duplicates’ and ‘update when duplicated’. For this syntax
to work, the corresponding constraints must be defined in the respected table schemas. Here is an example from my own code: