Unable to disable prepared statements for Retool DB enviroments other than production

[dobatovkin]

There is only one settings page for Retool DB where you can enable the Disable converting queries to prepared statements option. While using other environments than the default production I get errors with queries that need that setting turned on. It is clear that SQL injection protection is turned on here as staging environment uses prepared queries.

Is there any other way to turn off queries converting to prepared statements?

[joeBumbaca]

Hey @dobatovkin! Thanks for the report, I was able to reproduce the issue and have submitted a bug report / feature request to be able to turn off prepared statements for RetoolDB environments other than production. I'll update this post when I have any additional information.