I'd like to do some arbitrary rotation of spatial objects in spatialite (accessed through QGIS). In PostGIS I'd use something like:
... SELECT geom AS ST_Rotate(geom, radians, originX, originY)
Is there an equivalent in spatialite?
Edit: after the answer and some more research, managed to find a way of mimicing
RotateCoords, rotating by 45° around the centroid in the example below:
SELECT ShiftCoords(RotateCoords(ShiftCoords(GEOMETRY, -X(Centroid(GEOMETRY)), -Y(Centroid(GEOMETRY))), 45), X(Centroid(GEOMETRY)), Y(Centroid(GEOMETRY))) AS geom from TABLE