"You have no control over what queries it writes"

Huh? Just write a view or a stored procedure and point Tableau at that. There's no need to compose a query in the Tableau interface.