WHY SQLITE USES BYTECODE

Summary from the TLDR newsletter

SQLite uses bytecode because bytecode is easier to understand and debug, smaller than the corresponding AST coming out of the parser, faster because fewer decisions need to be made for each computation, and can be run incrementally.