From Xojo Documentation

Property (As Boolean )
aREALSQLdatabase.ShortColumnNames = newBooleanValue
BooleanValue = aREALSQLdatabase.ShortColumnNames

Supported for all project types and targets.

If True, REALSQLdatabase will use the column names as they appear in table schemas for query results whenever it can. Aliased columns and ambiguous columns will be fully qualified.

If False, REALSQLdatabase will return column names exactly as they appeared in the original query. The default value is True.