Example query: select Thing.thingID, CONCAT_WS(' ', Thing.title, Thing.version) as title from Thing This throws an exception in sqljocky but it is a valid query that I use from Node.js, command line and phpMyAdmin query tools, etc.