For older versions of android < 10, upserts do not seem to be working. I am trying to run a simple upsert and constantly getting this syntax error when it gets converted into SQL: near "ON": syntax error (code 1 SQLITE_ERROR): , while compiling: INSERT INTO dummy_table (name_id, date, dummy_value) VALUES ('abc123', 1717200000, 1212) ON CONFLICT (name_id, date) DO UPDATE SET dummy_value = excluded.dummy_value;