I want to do a database-side string concatenation in a Rails query, and do it in database-independent way.

SQL-92 specifies double-bar (`||`) as the concatenation operator. Unfortunately it looks like MS SQL Server doesn't support it; it uses `+` instead.

I'm guessing that Rails' SQL grammar abstraction has solved the db-specific operator problem already. If it does exist, how do I use it?