I have a memory layer loaded in the QGIS virtual layer in the data source manager. I am trying to run a very simple query:
select * from layer
While this works for the physical layer, it does not work for the memory layer. They output virtual layer is blank, and I know that my memory layer has attribute data.
Is this simply a bug? I want to keep this a memory layer to reduce the number of steps I need to do to arrive at my final result. Should I resort to another tool or is there a workaround?
Also found this quote in this link:
Creating a virtual layer with the layer_ref key allows to directly access already loaded QGIS layers (including memory layers).