Hey @Tess. Yes, I checked this box after posting this and it worked, I just didn't come back and update the forum.
I will say, it's a bit tricky to get some of the MySQL Queries working in this manner, but seems to work nonetheless.
Hi @Greg_J! Glad that solved it! We typically recommend keeping it un-checked unless you really need to disable the setting (for security reasons). In cases where it solves issues with queries, we often recommend setting up another copy of a resource with that setting enabled to help limit the surface area that you have to keep in mind SQL injection for.