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. [Screen Shot 2020-05-20 at 9.01.09 AM] All of that being said, this component i…

How to use querybuilder component's sql in query

💬 Queries and Resources

victoria Split this topic November 6, 2023, 9:58pm 6

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

Topic		Replies	Views
Syntax error at or near "$1" 💬 App Building sql	2	286	October 28, 2024
QueryBuilder generates wrong column name for mySQL 💬 Feature Requests	1	1064	April 27, 2021
Formatting the output from QueryBuilder.asSql 💬 Feature Requests	1	1011	July 14, 2021
QueryBuilder format errors 💬 Queries and Resources mysql	3	2173	August 2, 2023
Query builder and table 💬 App Building	1	731	August 11, 2023

How to use querybuilder component's sql in query

Related topics