@gilcrest, we recently pushed out a feature to address called "Failure conditions." Basically we let you on certain conditions either:
- Mark a successful query as a failure (like error transformers)
- OR convert the error message of an already failing query. (your use case)
This feature is currently behind a feature flag, so you'll have to go to https://yourOrgName.retool.com/settings/beta to enable it. It's the "Mark queries as failed" option. (Once you set turn this flag on, you have to refresh your app editor page and you'll see a new tab in the bottom Query Editor).
I'd love if you tried it and let us know if this works for you!
