I'm trying to load the spatialite extension for SQLite.
The module is on the PATH but rider can't find it / won't load it.
SELECT load_extension('mod_spatialite.dll'); ->  [SQLITE_ERROR] SQL error or missing database (The specified module could not be found. )
I've tried to add it to the startup script as well as from the console.
My unit tests can load the extension and interact with the db but now I would like to use riders smart sql features for further development.
Any trouble shooting ideas?
Thanks in advance.