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

[jagadeswarand]

[MikeCB]

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":

Then check this box and hit save.

Again, this does open you up to SQL injection attacks, so be very careful with the source of your data.

[bobthebear]

id highly suggest cleaning input on the DB if you choose this route, instead of on the front-end unless you have an api inbetween to do that for ya