I am going to executing this through DBI. I needed the column aliases to write out to a flat file for use by a third party application. This application is very picky about column headings forcing us to use aliases. I didn't know about  $sth->{NAME_lc}, I will look into that now.