Quoting the SQLite docs, https://www.sqlite.org/c3ref/complete.html:

If a memory allocation fails, then SQLITE_NOMEM is returned.

For this condition, sqlite3.complete_statement should raise MemoryError.