I'm creating a layer with single sided buffers based on a line layer as virtual layer in QGIS with the following query:
SELECT
id,
ST_SingleSidedBuffer(layer.geometry, layer.buffer_dist, layer.side)
FROM
layer;
The buffer distance and the buffer side for each feature ist stored in the attribute table.
I would like to the set the join style to 'MITRE'
. I found that there should be a way to set the option like this (https://www.gaia-gis.it/fossil/libspatialite/wiki?name=BufferOptions):
SELECT BufferOptions_SetJoinStyle('MITRE');
Unfortunately I get the following error message:
Query preparation error on PRAGMA table_info(_tview): no such function: BufferOptions_SetJoinStyle
Hence my question: Is there a way to set the buffer options globally in the QGIS project? Or is there a way to set the buffer options within the query?