When I try to do some spatial query in the DB Manager (as Virtual Layer Provider) or in the Virtual Layer Window (Layer > Add new Layer > Create Virtual Layer...) it returns a NULL array, as it doesn't understand the GEOM field.
This happens with GPKG and KML. Although it doesn't happen with SHP. I tried with a KML layer (original), then I converted to GPKG and SHP. When queried in the BD Manager in GeoPackage Provider, it worked.
Is this an issue or exists an explanation?
I searched about it, but I didn't understand the conclusion.
DISCUSSION:
Geopackage - select on geometry column returns null ;
https://github.com/qgis/QGIS/issues/27914
SELECT * FROM layerSELECT st_buffer(geom, 1) FROM layer– MarceloBaliu Sep 04 '20 at 14:58ST_have the same result. – MarceloBaliu Sep 04 '20 at 15:03