sql-builder
sql-builder copied to clipboard
comma between multiple insert VALUES missing?
I'm not sure about this, also pretty new to SQLite and it's been pretty long in general since I dealt with SQL, though I get the same error trying to run the produced query in "DB Browser for SQLite" desktop app which I only resolve by adding a comma between the multiple VALUES ),(
SqliteError: near "(": syntax error
at DB.prepareQuery (https://deno.land/x/[email protected]/src/db.ts:250:13)
because the builder generates ) (
INSERT INTO `users` (`id`,`name`,`email`,`password`) VALUES ("ID1","name","email","hashedpwd") ("id2","name2","email2","pwHash")
strange, when trying to fix this in a local fork I get another error that there's no such column which then refers to a value, though copying the exact statement into DB Browser works as expected
also this lib doesn't seem to be really maintained 😬