0.19.0

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 │
└───────┴───────┴───────────┘