I have a textinput that is used as an argument for creating a new column in my PostgreSQL db.
My SQL code is:
ALTER TABLE hydra ADD {{textinput5.value}} INT;
where the textinput value may be something like "eggs". After submitting, I get an error "syntax error at or near "$1"". Not sure what the issue is, I'm very new to Retool.
Hey @kevinTDS! This probably has to do with prepared statements. To interpolate JS into your query you'll need to disable them in your resource's settings.