Does Alteryx now how to handle SQL aliases?

[ckelley0]

I have a very simple SQL query that works, but not when I include an alias.  

While it is not a problem to simply remove the alias for this query, it is not ideal for more complex queries.  Thanks.

[ckelley0]

Never mind, I found my issue.

If you are going to declare an alias then you have to use it. 

 

[apathetichell]

The short is Yes - it can also handle subqueries with alias ie select s.* from (select sum(*) from yourdb.yourschema.yourtable) s