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

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.

2 Likes

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: