Hi all,
We’re seeing a system-wide issue across one of our clients' Retool apps where multiple queries are failing on page load and across modules.
There were no recent changes on our end, but we’re now getting errors like:
- invalid input syntax for type integer
- trailing junk after numeric literal
- syntax errors due to unquoted text/UUIDs
Example pattern:
SELECT * FROM app_users WHERE retool_id = {{ current_user.id }}
Now needs to be handled as:
SELECT * FROM app_users WHERE retool_id = '{{ current_user.id }}'
So it looks like stricter runtime handling is now surfacing:
- empty values (
"") - unquoted text / UUIDs
- inputs that previously didn’t error
This is affecting multiple modules simultaneously, which suggests it’s not isolated to a single query or screen.
Questions:
- Has anyone else seen similar behavior recently?
- Was there a recent change to how Retool handles query inputs/interpolation?
- Where can we get reliable information on these types of updates?
The changelog and blog are helpful, but tend to be high-level and don’t always capture runtime/behavior changes. - Does anyone have an internal process for monitoring Retool Cloud updates or catching breaking changes early?
We’re currently working through a stabilization pass, but wanted to check if others are seeing the same thing or if there’s any official guidance.
Thanks!
