I've been trying to set up a filter and have it working fine when the value the user selects in the filter is meant to be injected directly in the SQL (ie. WHERE product = {{product_name}} ). How can I manipulate the value the user enters to produce a different string for SQL purposes (like with string interpolation)? In another filter we ask the user for a date, but we have to set the correct timezone on that date for the query to work, so that we end up with a query like
SELECT * FROM plus.get_policy_chars_snapshot_in_time('2025-01-01 00:00 America/Los_Angeles', '2025-01-21 00:00 America/Los_Angeles', true)
(Note this is running a database function, not querying a table or view, in case it's relevant). I would be looking for something like this
SELECT * FROM plus.get_policy_chars_snapshot_in_time('{{start_date}} 00:00 America/Los_Angeles', '2025-01-21 00:00 America/Los_Angeles', true)
that would let us plug the filter value into a string built for the query. I have tried every variation I can think of, and have not been able to find docs on how to manipulate the text. Thanks