The same 3 types that share indexing operator (str,
bytes, and arrays) also share the ability to concatenate
two values. The ++ operator is used for that purpose:
SELECT 'Hello' ++ ' world';
SELECT b'byte' ++ b'-string';
SELECT [1, 1] ++ [2, 3];
Note that tuples don't have any concatenation operator.