whwnever i do a select on a table, i see a huge select statement with table name alias and column name alias for each column. this is causing bandwidth issues with database, it just carries unnecessary baggage. i can understand why they are doing, if we join 2 table there could be issue with column names being repetead

but is there a way we can specify our own short alias for columns ? i dont find it in the documentation.

example ;

select employee0_.employee_KEY as employee_key_132_0, employee0_.employee_NAME as employee_name_132_1, employee0_.join_date as join_date_132_2 from employee_records as employee

i want this as

select emp.employee_KEY as e_k, emp.employee_NAME as e_n , emp.join_date as j_d from employee_records as emp


Thanks