I have an application that stores its data in a SQLite database. I can't modify the application or database to add geometry extensions, but it does already have latitude and longitude columns for each row of data it stores (stored in decimal format).
How do I tell QGIS to look at these columns to generate x,y points? If I dump the database to a CSV file, I just have to choose the X field and Y field for lat and long under "Point Coordinates" when adding the layer. I'm essentially looking for a way to do the same, but with a SQLite data source.
Here's how the SQLite data source looks when loaded in QGIS as a vector layer:
I'm trying to turn each of those rows into a point.