Hi,
I want to perform the following custom query within API Express:
SELECT *
FROM [database].[dbo].[table]
where
Geometry::STGeomFromText('POLYGON((-115.2348 54.9285, -114.0511 54.9285, -114.0511 55.6325, -115.2348 55.6325, -115.2348 54.9285))',4326).STIntersects([Geometry])=1;
Unfortunately the syntax of creating a new instance of geometry (https://docs.microsoft.com/en-us/sql/...) gets interpreted as a SQL PARAMETER "STGeomFromText".
How can I avoid this? As far as I know I can't change or encodde that SQL syntax.