|| operator performs string concatenation in SQL. It is worth mentioning that 'some_string' || null will return 'some_string', not NULL as some might expect it to.