Allow unprepared (raw) SQL statements on a per-query basis for Retool DB

💬 Feature Requests
, , ,
1

Please allow for individual queries to use unprepared SQL statements, for dynamic SQL.

A simple and relatively safe use case is when I have a table with multiple columns of the same type and similar data, but I may want to only update one of those columns with each query execution. I want to be able to dynamically name the column that I want to update with a variable.

Currently there is a way to disable prepared statements globally for an entire retool database, but this will break any pre-existing queries that use prepared statements. I want to be able to disable prepared statements for specific queries, which is much safer and much more practical.

3 Likes
2

Hey @meanmrmustard! I believe this post is a duplicate feature request as there has already been a ticket created. We'll be sure to update you when there has been an update. :slight_smile:

3

Hello @Darren do we have any updates on this. It would be very helpful to have this functionality

Edit: One workaround found was to use the Retool database GUI, which allows to pass an object to the db:

image
image688×458 22.9 KB

1 Like
4

Hi @fmaltafleury-techinsights,

Great work around! Unfortunately no updates on the feature request.

Darren is out of office currently but me or him will post in this thread with any news we hear on that feature request :+1:

1 Like