Set dynamic conditions

[gaspar-tovar-civitas]

Hi!

Am trying to set something like this

SELECT {{ fields }}
FROM {{ schema }}.{{ table }}
WHERE {{ conditions }}

fields, schema and table are working just fine, the issue is on the conditions. When I use something like

field = 1

works well, but when using

field > 1

Is not actually an issue but if there is an answer out there it would be much appreciated.

[RasterBurn]

It's probably trying to escape the >. You probably need to apply a "raw" filter or something like that

[erikswedberg]

[RasterBurn]

🌮

[RasterBurn]

also, why template a query like that? At this point you might as well just write out the whole query. You're not saving yourself any trouble by factoring out "SELECT" "FROM" and "WHERE".

[gaspar-tovar-civitas]

You do have a good point Ill check it out, and it did work with the 'raw' filter. Thanks for the help!