Can sqlite3_step stream the results of a query from disk in some cases, without loading them all into memory at once? For example SELECT * FROM my_table ORDER BY rowid would this load all the results into memory before the first call to sqlite3_step has returned? Even if no, are there other cases when all…