Issue
I had a problem where changing the data source host address in Appsmith did not update the Queries I had already written. Even though I selected the updated data source, the Queries still used the old data source.
Resolution
The issue was that after changing the host location of the data source, the queries were still using the old data source and not updating to the new one. The solution was to test and save the updated data source. However, in this case, the user ended up switching to cloud hosting on the Appsmith side and AWS RDS database. If others encounter a similar issue in the future, they can try testing and saving the updated data source and rechecking their queries.