[Screenshot 2024-06-20 103432]

Hi @jagadeswarand , This is because Retool uses prepared statements to help prevent against SQL injection. While not recommended unless you fully understand the risks, you can go to the Resources tab, click the settings button on "Retool Database": [image] Then check this box and hit save. [imag…

Message:"syntax error at or near "$1""

💬 App Building

AbbeyHernandez Split this topic July 18, 2024, 8:49pm 4

A post was split to a new topic: Enable raw SQL queries on a per-query basis!

Topic		Replies	Views
QueryBuilder format errors 💬 Queries and Resources mysql	3	2122	August 2, 2023
Syntax error at or near "$1" 💬 App Building sql	2	155	October 28, 2024
FROM database_name as db >>> FROM {{select_table.value}} as db 💬 Queries and Resources	8	1310	August 3, 2023
SQL bind error, 6 parameters but requires 0 💬 Queries and Resources	12	9020	August 2, 2023
Transformer value run as a SQL Query 💬 App Building welcoming-replies	3	163	September 16, 2024

Message:"syntax error at or near "$1""

Related topics