The problem with using raw SQL mode is that I am trying to update multiple columns and multiple rows using the changeset array, and with raw SQL mode I have no way to use the changeset array.
Thank you for the details!
I will keep you updated on what I hear from the engineering team. I apologize for the frustration.
Retool was not designed to dynamically change resource details, but we have been working to improve this capability for re-using resources and queries 
I am surprised the override is not working, we will investigate this and work to get it fixed or find a workaround that would be suitable for the use case if possible!
Hello Jack.
Since this is a bug, I need it to be fixed as soon as possible, as it prevents me from using your tool. Your tool allows overriding the db name and db host fields, so it must work correctly, whether using an SSH connection or not.
I pay for the license every month, so everything is supposed to work correctly. Since this is a bug, the priority to fix it should be the highest, and that is what I expect. Otherwise, unfortunately, I will have to find another tool.
Knowing your tool, I believe it shouldn't be very difficult to fix this issue since it doesn't happen in SQL Mode.
Hello Hugo,
I understand your concerns, our engineering team is working on adding in the functionality for GUI mode but I can't make any promises about how soon this feature will be finished and ready for release.
In the meantime, the best workaround to accomplish the functionality you are after is to use the recently released feature "Dynamic Queries". It had been in beta, but is now publicly accessible to all orgs on cloud.
Dynamic queries enable users to access several different resources from a single query. As you had mentioned before, all the Resource information is the same besides the DB Host and DB name.
Although it is going to involve you creating nearly the same Resource but with only those two variables changed, it will allow you to dynamically pass in the resource ID for the correct table/host which you want to update to the query, and this will work with your GUI mode MySQL queries.
You can read about the feature and how to use it here and here.
You can find the query ID in the resources URL as explained in the second link above as Kabirdas lays out in his comment.
You can save these URLs to an object in your app and key into this object with something such as the table name and then use {{ }} to fill in the Resource ID.
I know this is not ideal but it should work so that you can use the GUI feature to update multiple rows at once and you will be able to dynamically do this with as many tables as you want for now while we work on implementing DB override.
Hope this helps! 
Hello Jack
Sorry but I disagree with you… this is not a new feature this is a bug. If GUI mode already offer the way to override de host and db name it must work with or not with ssh…
I don’t know you but in my company a bug have a very different priority