Take the 2-minute tour ×  I have a spatialite database I created
that spans several years of crime data. To facilitate a real-
world scenario where I may simplify the interaction for a user
by introducing a View that simply limits the time span or what
types of crimes are returned, I want to know if it is possible
for QGIS to read this View like it would any other spatial table
in my database. The point here is that I obviously do not want
to create a separate table for every possible View I may use,
and I am trying to make it simple by not requiring the user to
know the database and the appropriate SQL to subset the data
themselves. A similar workflow in the ArcGIS world might be
creating separate layer files that the user could open in ArcMap
that access the database (say, SQL Server) and present only the
limited data set.  I created a View in my database, but it does
not show up in the list of feature classes I can import when I
connect to the spatialite db in QGIS. Maybe Views aren't
considered spatial? (T