@joshdb/sqlite actually does this to a point : batching of 10 records at a time. There's a potential balance here between performance and memory usage, since capturing smaller number of rows per batch means we're doing more queries but using less memory, less processing...
Important to do some performance testing here.