Syntax error at or near "$1"

[tomm]

I am using the following sql to attempt to pull back data from a Google Sheet.

SELECT
  date_shipped, dealer, model, color, address, serial_no, sales_order, customer_name
FROM
  {{query1.data}}
WHERE
  dealer ilike {{ '%' + textInput4.value + '%' }}
ORDER BY date_shipped ASC

I keep getting "Syntax error at or near "$1""

There was no option in settings that said "Disable converting queries to prepared statements"

Can anyone explain what this error is and how to fix it?

[ZeroCodez]

Hii @tomm ,

The post describes preventing SQL queries from automatically converting to prepared statements.

How to use querybuilder component's sql in query

Hi all! I’ve got a querybuilder component and would want to use it’s asSql property in a Postgres query. But SELECT * FROM table {{queryBuilder.asSql}} formats the asSql as a string, which creates invalid SQL. Any way to force placeholders to skip formatting and use them in place as is?

Feel free to ask if you need further assistance or have additional questions. We're here to help!