merge two column into one field in sql and hql

some times, we want to consider two columns in db as one field in service, for example, we'll save first name and last name seperately in db, but in UI, we want to display them together.

In this case, we should consider the two columns as one, and in sql, we can do the query, such as:

select first_name + ' ' + last_name as name from user

In HQL, we can also do this, like:

select firstName + " " + lastName as name from user

In QBC, I'm not sure whether there is such functionality, but I'm afraid not

I'll do confirmation tomorrow.