SQLite Forum

multiple queries
Login
You might do a search on "parser" and "error recovery" (together.) As you will see, it is not a trivial task.  I am not surprised that the SQLite parser has not been made to somehow figure out what should be consumed as erroneous while leaving what is maybe not.

If you insist on solving the problem, finding a statement separator not embedded in quoting delimiters is likely your best bet. You will need to replicate the SQLite scanner (or "lexical analyzer") for that.

I am curious as to what the application is that makes solving your stated problem preferable to just complaining about the whole conglomerated statement sequence.