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

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.

image

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

1 Like