Is it possible to select all columns except geometry using virtual layers in QGIS?
For example I have this (simplified) query:
Select *, st_buffer(geometry, 100) From mypolygons
It does not work. It does not buffer at all. But using the (simplified) query as follows does buffer all polygons as intended:
Select id, name, st_buffer(geometry, 100) From mypolygons
Now the issue is, that if I have polygons with a lot of columns I need them to type in all manually. Is there a way to avoid this?