sql.js is in memory, but the database file is only partially loaded from the static file host.

No, as other comments have noted it's stored in S3.