i've converted an OSM file from Geofabrik to an SQLite database and loaded it into the QGIS DBManager (QGIS 3.12). I've executed the following SQL query and got a nice table as result.
SELECT * FROM points WHERE place = "city"
Yet when I try to load the layer into the canvas using the Load button (and with the settings seen in the screenshot), I receive the following vague error:
There was an error creating the SQL layer, please check the logs for further information.
There's nothing to be seen in the logs.
Does anyone know how to fix this?