Transformer value run as a SQL Query

[MiguelOrtiz]

Hi @esattav,

I think you'll find a solution to your problem in this post:

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": [image] 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.