Family Law and Divorce

How can I generate a custom – UUID with some salt/ private key out of some string column in table from sql-query?

let say we have a Table of employees having the column EmployeeName, Department:

EmployeeNameDepartment
JohnHR.
JennyTech.

I want to have a new column in a view taking EmployeeName as data along with static private-key. Don’t wanna change the table structure, but just to get UUID in select query For eg: select EmployeeName, Department, UUID({private-key},EmployeeName) as UUID from EmployeeTable

View result example:

EmployeeNameDepartmentUUID.
JohnHR.f1cf5eqf0-63c6-11ec-90d6-0242ac120003
JennyTech.z1cf5emk0-63c6-11ec-90d6-0242ac120003

is this achievable?