The BASIS ODBC Driver 2.0 is capable of using nested column name abbreviations in queries, for example:
SELECT i.item_num, i.prod_cat, c.cost_method FROM item I, category cWHERE i.prod_cat=c.prod_cat