I have a geopackage table/layer of buildings. I need to "offset" by using ST_Translate. https://postgis.net/docs/ST_Translate.html
SELECT ST_Translate(geom, 1, 1, 0) FROM "building_UTM" works when ran in the SQL Window of the DB Manager.
However, if the same expression is ran via the Query Builder/Filter function, it doesn't work and returns the following error
An error occurred when executing the query.The data provider said: OGR error 1: Undefined function 'ST_Translate' used.
I'm sure that this expression ran as expected in the Query Builder in my other laptop.