$concat broken for SQLite

[lukesrw]

SQLite does not support the CONCAT() function, so $concat does not work.
Instead, the SQL implementation for CONCAT should seperate strings with pipes.

So MySQL:

SELECT
    CONCAT("one", "two", column1)
FROM
    ...

Should be:

SELECT
    "one" || "two" || column1
FROM
    ...