SQLIte integration: How to Load a SQLIte Extension on a per database basis?

[asitemade4u]

Context: I am using Spatialite on SQLIte and its requirement is that a library be loaded for each database. As I work on Ubuntu, the path of the library is /usr/local/lib/mod_spatialite.so
If I do not load the library, the extension sends an error about VirtualElementary, which is precisely related to Spatialite [see detail here]

My idea: in self contained SQLite GUIs, such as the SQLite Studio or DB Browser, there is a setting that allows to load a library by providing its pathway, either for all databases or on a per-database basis.
It would be great to implement this kind of function in the extension,.

Alternative: the other solution would be to automatically execute a SQL query every time a database is connected, then an instruction such as SELECT load_extension('mod_spatialite')

Details: Ubuntu 18.10, Node 8.11.3, last version of VS Code

[mtxr]

For future reference: https://github.com/mapbox/node-sqlite3/wiki/Extensions