I'm not able to concat strings because of parse error , do you have a way around this ?

Simple Example here:

Select 'hello' || 'You'

should result in helloYou with no error

this works just fine in any sql command