the as attribute has absolutely *NOTHING* to do with 
the SQL syntax  SELECT foo AS bar

it is used to specify how the columns will be accessed