I am trying to wrap my head around spatialite views in QGIS. However there are severe limitations that make it very cumbersome:
- Spatialite views in QGIS do no update, if the corresponding tables in the DB change Edit: they do in fact update after restart, views behave differently (see comments)
- It is not possible to create virtual fields for spatialite views
- Attribute types that are defined as INTEGER revert to STRING in the View layer
I often have independent layers (points, polygons) that are connected by a foreign key. The spatialite views join and filter these together.
How are you addressing these issues?