> parsing it can get hairy That's why there is the [sqlite3_complete()][1] interface! The sqlite3_complete() function takes care of all the messy details for you and lets you know, whether or not the semicolon you found is the end of an SQL statement, or if it is embedded in the middle of an identifier or string literal or trigger. [1]: https://www.sqlite.org/c3ref/complete.html