Is there any mechanism for saving the results of a query so that I can reuse it the next time I run this query? I'm not talking about SQLite cache, which stores pages retrieved from a database file. This is more like executing a query without using SQLite B-tree and Pager modules.
If you are talking about Statement cache, SQLite does not provide a cache function statement.
You create your own cache after executing the request using C syntax to support the array sqlite_stmt*
sqlite_stmt*