Hi Douglas Gooding ,
If I am not wrong ,in MySQL connection there's the option of Initial SQL .Please have a look .
Click on Initial SQL
You can write your query here . But yes , you need to customize your query a bit .
Few links added here ::
And if I missed something please explain it in detail what exactly you are looking for .
I have spoken with several others in my organization, all running version 10.1.9 and none see the option for Initial SQL for MySQL connections.
Hopefully someone else has run across this and can offer a reason for the missing option.