HQL defines two ways to concatenate strings:

• the SQL-style concatenation operator, ||, and
• the standard concat() function.

These can be represented in MQL using the $concat expression