Hi,

I'm currently working on an Ionic app that we recently updated to use Capacitor 5, TypeORM, and capacitor-community/sqlite for data storage. Previously, we were using an older Cordova setup.

We're encountering an issue when saving entities: if a string object contains the 'returning' keyword, we encounter an error.
e.g. "This is a string including returning that we want to save" the generated query logged by TypeORM:

query: INSERT OR REPLACE INTO job ("guid","unitGuid","deleted","baseUnitGuid","modified","retrieved","jobNo","name","text","latestJobHistoryRemark","nextDate","componentGuid","componentNo" ) VALUES ("94787267-f411-4132-a79e-3b479b494236","d06b3fe3-c5e1-4a0b-bb92-bfcb37dbe582",null,null,null,null,"test","test","This is a string including returning that we want to save",null,"2024-01-15T00:00:00","3c48cf1f-9b3e-43dd-92a0-dcc0e326b94d","Comp2")

The error generated:
error: Error: Run: unrecognized token: ""This is a string including;": , while compiling: INSERT OR REPLACE INTO job ("guid","unitGuid","deleted","baseUnitGuid","modified","retrieved","jobNo","name","text","latestJobHistoryRemark","nextDate","componentGuid","componentNo") VALUES ("94787267-f411-4132-a79e-3b479b494236","d06b3fe3-c5e1-4a0b-bb92-bfcb37dbe582",null,null,null,null,"test","test","This is a string including;

I'm uncertain whether this issue is related to TypeORM or SQLite, but based on the console log, the query generated by TypeORM appears to be correct. Therefore, I suspect it might be a bug or issue within capacitor-community/sqlite.

Could someone help me figure out what's going on and possibly provide information on how to resolve the issue? This is a critical issue as our app is actively used by customers, and currently, they are unable to synchronize their work if any of their strings contain the 'returning' keyword.

Thank you!

Update just tried downgrading to 5.0.4, and it works as we expect. So my guess is that the error has something todo with the 5.0.5 release "add insert/delete/update with returning" 293f032