I have several shapefile vector layers that I need to query so I can group records and export a subset of fields to go into an excel spreadsheet. I thought I could do this by using the graphical modeler and simply using the 'Execute SQL' algorithm on the input layer and then copying the records into excel. When I try to do this, I get an error that it cannot find the virtual layer ("virtual: Cannot find layer [generated temp file name]").
Can this be done on shapefile layers or do they need to be in a database layer? Is there a better way to do this?