Suggest new InlineQuerier Parameter “Use Spatialite Extension?”
No secret that I have been a SQLite/Spatialite fan, albeit very much from my SQL background 😉
Still today though, there are certain operations that these SQL approaches are simpler and faster than FME Transformers. What has been missing though is the huge library of Spatial SQL functions that could be utilised by InlineQuerier, if it had a Parameter to load the Spatialite extension. This would significantly increase the workspace flexibility in being able to mix FME Transformers with in-workspace Spatial SQL parsing.
Essentially this would provide FME with a ready-made spatial SQL black box with 100s of spatial functions to support its existing Transformers.
https://www.gaia-gis.it/gaia-sins/spatialite-sql-5.1.0.html
I believe that it is likely all the Parameter setting would need to toggle is an initial DB SELECT statement to be run immediately after DB open:
SELECT load_extension('mod_spatialite'); or SELECT load_extension('libspatialite');
https://www.gaia-gis.it/fossil/libspatialite/wiki?name=mod_spatialite
...and ensure that mod_spatialite or libspatialite was resolvable to the Spatialite DLLs that are embedded inside FME already due to its Read/Write support for Spatialite (although updating them to the latest would be nice as well! Alessandro: Spatialite author has spent a lot of time creating new SQL functions for Eg. Network tracing, Topology etc. not yet available to FME because of outdated DLLs)
