Select query with custom column and value of other column
The answer Is Concat

You can use concat to combine an array and value of column

example query:

Select id, name, emp_id, concat("Work of ", name) as process, from table1