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;

The query works on iOS and newer versions of android. Maybe upserts using the ON CONFLICT syntax isn’t compatible for such versions? If so, is there maybe a workaround to that?

I am pretty much facing the exact thing this person is facing in this thread: https://github.com/expo/expo/issues/16776