At 3.28.4, I am trying to automate a series of manual steps using the Model Designer.
One of the manual steps that I would like to automate uses the Layer > Create Layer > Create Virtual Layer tool. However, this tool does not seem available to the model environment, nor can I find an equivalent in the Processing Toolbox.
There's a similar SEGIS post from 2017, but the answer required code, and I am not a programmer.
How can I create a Virtual Layer in my model?
Edit:
Matt's proposed answer - to use the Execute SQL tool - works with one exception: it always outputs a point layer (with EPSG 4326), even though:
- My input is a non-spatial Geopackage table
- I use either the Not Selected, Autodetect, or No Geometry Geometry types (screenshot below).
I need a non-spatial Geopackage table output.
(Maybe this should be a separate SE post regarding the Execute SQL tool???)