The difference is that in SQL this is completely not supported:

select a from ADDRESS a. That is complete gibberish to a SQL parser. Put more generically, in SQL it is completely not valid for the from-clause alias to be used as an expression. So there is no possibility of a clash between same-named aliases as an expression.