Good points. I believe the lexer is put to work behind sqlite3\_complete()'s operation. The shell presently relies on sqlite3\_complete() to help determine when to process the input instead of merely continuing to collect it. And it demands a terminating semicolon. So Mr. Jones' suggestion is already effected as much as it reasonably can be (in my opinion).