sql.js-httpvfs allows read only sqlite database in a static website. To learn more more about it - https://github.com/phiresky/sql.js-httpvfs
This project is an implementation of sql.js-httpvfs in svelte.
Took help from https://github.com/nishad/analyze-sqljshttpvfs and using his statically hosted database in this example.