If you add allowMultiQueries = true to the Extra Configuration Properties in the advanced database connection properties, you should be able to use MySQL variables in the query. The query, however, can only return one dataset.
https://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html