WHY SQLITE USES BYTECODE

Summary from the TLDR Web Dev newsletter

SQLite uses bytecode to represent prepared SQL statements. This is because bytecode is easy to print and review. It also makes debugging easier because it separates the SQL parsing stage from the SQL execution stage. As SQLite is designed to run within the same process as the application, bytecode allows SQL statements to be executed step-by-step.