Exactly what I did was use aliases however in grid view, manual export to csv and in automation designer - export dataset it changes the headers case to all caps regardless of alias mixed case. The only option available is all lowercase in the export dataset screen. Support case 4821414 said that is not possible.
SELECT ROWNUM "0",
TRIM(CLASS_SECTION) || ' ' || SSR_COMPONENT section,
'Queensborough Community College' campusTitle,
-- (((TRIM (SUBJECT) || '-') || TRIM (CATALOG_NBR)) || ' ')
-- || TRIM(CLASS_SECTION) || ' ' || SSR_COMPONENT
exports all cap headers: