Dynamic resource queries blocked in public app — but same pattern works in another release

[WidleStudioLLP]

Hey @ORATHAI_UDOMLUK

I came across this forum post, which seems to provide a solution to the issue:

Dynamic SQL Query

I want to build a SQL playground in App mode A TextInput where user enters SQL query - “sql_query” A MySQL resource query using {{ sql_query.value }} A button to trigger it A table to display results Is dynamic SQL execution intentionally blocked in MySQL resources in recent Retool versions? Please advice. Regards [image]

I also tested it on my side, and it appears to be working as expected. I've attached a couple of screenshots for reference.

Please let me know if it works for you. If you run into any issues or have any questions, feel free to let me know—I'd be happy to help.