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?

Alright @artman got a solution for you. The problem is most likely related to how we handle prepared statements. If you check this box in your resource's settings, the .asSql property should start working as expected.

All of that being said, this component is pretty buggy right now, so keep us updated as how this goes.

3 posts were split to a new topic: Prepared statements error with query builder component