I am currently using OGC GeoPackage features and tiles which is another spatial data format that is also a SQLite3 container.
I am using it in a mobile app but GeoPackage does not support spatial queries and spatial functions like SpatiaLite. I see there is a new feature of SpatiaLite that's a virtualgpkg. Like their virtual Shapefile.
Trying not to reinvent the wheel and take advantage of this cool feature and all the functionality.
In the reference of SpatiaLite 4.2.0 the syntax for creating virtualgpkg is:
CREATE VIRTUAL TABLE tablename USING module(arg1, ...);
I need more examples of the syntax. How it references a GeoPackage Filename
and the GeoPackage Tablename.
Can someone provide the code to create a virtual GeoPackage table in SpatiaLite?