You can modify the SQL code that the Query Designer has created.

HOWEVER, once you do this, you can not use other the Query Designer functionality to maintain the query. You must maintain the query using the Advanced tab.