I wonder if they're using appendvfs, too https://www.sqlite.org/src/file/ext/misc/appendvfs.c
> This file implements a VFS shim that allows an SQLite database to be appended onto the end of some other file, such as an executable.
(A quick search of their codebase reveals no results for "appendvfs", so I guess not. So single-file was a lie!)