So from dbeaver I can do something like this
select * from sample_tbl where has_match is :value
But if I do the same in tulip connector function
select * from sample_tbl where has_match is $value$
it throws
SQL Test Error
Error: [500] SQLQueryFailureError: The SQL query specified by the connector function failed to execute successfully: Postgres Connector encountered an error during query: syntax error at or near “$1”
If I change syntax to
select * from sample_tbl where has_match = $value$
it works, so maybe just stick with that syntax? I’m used to the IS TRUE type syntax