qmd query crashes with out-of-memory on large libraries (cross-collection)

[ChrisHorticulturalist]

QMD version: 2.0.1
Hardware: Apple M2 Max, 32GB RAM
Library size: 11 collections, ~56,000+ total chunks
Error: FATAL ERROR: Reached heap limit in Statement::JS_all when loading vector results
Workaround: -c collection-name scoped queries work fine, qmd search works fine
Cross-collection qmd query fails regardless of --max-old-space-size (tested 8GB and 16GB)

Go to:
The crash trace points clearly to Statement::JS_all loading all rows at once — a pagination fix on the SQLite query would solve it.