Hello once again, I am building a hybrid app (with...

# squarelibraries

[andylamax]

Hello once again, I am building a hybrid app (with both online and offline support) and I am trying an unorthodox approach of sharing some tables on the client side and the server side

The issue is that I need to write an SQL statement that is portable between SQLite (on the client) and MySQL (on the backend)

Take the following statement as an example

CREATE TABLE IF NOT EXISTS ow_core_people(
    uid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
    name TEXT NOT NULL,
    photo TEXT
);

Because AUTO_INCREMENT doesn't work on SQLite, it just works on MySQL but fails on SQLite.

Is there a way for SQLDelight to support these multiple syntax and transform them in accordance to the dialect selected?