Hey @Mark_Slade
One way I've found to execute more complex statements is to make them the output of a JS Query (but not a Transformer) and setup my SQL to do an EXEC with the result.
It's basically an end run around the prepared statement settings so be sure you aren't letting anyone inject things into your components.