[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
SQL bind error, 6 parameters but requires 0 💬 Queries and Resources	12	9486	August 2, 2023
QueryBuilder format errors 💬 Queries and Resources mysql	3	2173	August 2, 2023
FROM database_name as db >>> FROM {{select_table.value}} as db 💬 Queries and Resources	8	1412	August 3, 2023
Syntax error at or near "$1" 💬 App Building sql	2	286	October 28, 2024
Use Database Query to Populate Dropdown List 💬 Queries and Resources javascript , sql	4	4812	August 1, 2023

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

Related topics