[SPARK-4576][SQL] Add concatenation operator

The standard SQL defines `||` as a concatenation operator.
The operator makes concatenated string from 2 operands.
Is this the right place to add this given the precedence of the operator?