Open pdenapo opened 10 months ago
I have found that the code works by replacing excecute by executeMultiple. I think that this API difference is annoying and error-prone (if you won't output any error when multiple statements are in the input string).
Consider the following code
Only the table a is created. The second create statement is silently ignored.
This is different from what better-sqlite3 does. Supporting multiple statements would be useful for reading sql statements form a file as in the example at
https://github.com/WiseLibs/better-sqlite3/blob/master/docs/api.md#execstring---this