>I was curious so I tried this syntax on Postgres and it did not work as well. Personally, I like to see the table name as being updated. Updating an alias just seems wrong to me.

I agree but when doing an extended Update syntax, which includes an INNER JOIN, I think it is safer to use the alias.