Question mark being interpreted as a parameter in PostgreSQL statement

 

I am writing a query using a database select component. The query involves joining a varchar column with jsonb column.

 

Unlike the syntax for usual join (col1 =  col2), the postgresql syntax for this join is ( jsonbcol1 ? col2).   

 

While this syntax works in any other command line tool, pipeline pilot SQLSelect component interprets that question mark as an input parameter.  I tried passing "?" itself as the parameter value hoping that it will replace question mark with question mark in the process but that did not work.

 

Any ideas how to work around this issue?