I wonder how using SQLite like this compares to something like squashFS.

SquashFS is read-only and requires elevated permissions to mount, but also presents as a true filesystem.

As does:

https://github.com/guardianproject/libsqlfs

https://github.com/narumatt/sqlitefs

(I know nothing about these, just got them from a quick search)