Added the scanfile function to the fileio extension:
scanfile(path)
Reads the file specified by path line by line, without loading the whole file into memory.
sqlite> select rowid, value, name from scanfile('hello.txt');
┌───────┬───────┬───────────┐
│ rowid │ value │ name │
├───────┼───────┼───────────┤
│ 1 │ one │ hello.txt │
│ 2 │ two │ hello.txt │
│ 3 │ three │ hello.txt │
└───────┴───────┴───────────┘