Hibernate User Guide relevant section: https://docs.jboss.org/hibernate/orm/6.6/userguide/html_single/Hibernate_User_Guide.html#_coalesce

HQL example:

select coalesce(p.nickName, '<no nick name>') from Person p 

HQL's coalesce function can be represented in MQL using the $ifnull expression