I asked this in Slack, but realized that it would probably be better here for others who have a similar question.
Is there a way within QB to prepend additional raw SQL before the SELECT statement? For example, I’m doing some geography calculations that need to be set before my main query:
DECLARE @a geography;
SET @a = geography::STGeomFromText('POINT(#zip.longitude# #zip.latitude#)', 4326);
SELECT ...
It looks like the raw()
method needs to be called inside of select, from, join, etc…
If this capability doesn’t exist, maybe a prependRaw()
method would be a valuable feature addition to QB.