Define convention for handling duplicate column names

From Simba:

The following query returns the error "Duplicate result alias customerId.":

“select purchases.customerId, customer.customerId from purchases join customer on keys purchases.customerId”

This is not a viable solution for many BI tools. The equivalent SQL-92 syntax is perfectly valid because the column names are prefixed by the table: "select purchases.customerId, customer.customerId from purchases inner join customer on purchases.customerId"

The above query can work if aliases are appended to the column names. i.e. “select purchases.customerId AS customerId1, customer.customerId AS customerId2 from purchases join customer on keys purchases.customerId”