What I find interesting is that this approach means the query plan is chosen when "compiling" the statement, not when running it. However, there are still some

What I find interesting is that this approach means the query plan is chosen when "compiling" the statement, not when running it. However, there are still some cases where SQLite will recompile the statement when running, such as when the schema changed.