[jarito]

Second sentence in the linked GitHub:

While SQLite supports the special filename :memory: that allows the creation of databases in memory, there is no built-in way to populate such a database using raw bytes without hitting disk as an intermediate step. This virtual filesystem overcomes that limitation.

[throwaway81523]

I'm surprised writing to %MEMORY% hits the disk. Anyway ramdisks like tmpfs are a thing.