Function concat

concat(
dialect: Dialect,
...parts: StringSqlExpr[],
): LiteralExpression & { $literal: string }
String concatenation.
- MySQL, MariaDB, MSSQL, Snowflake, ClickHouse: use the variadic CONCAT(a, b, c, ...) function (all support 2+ arguments).
- Postgres, CockroachDB, Redshift, SQLite, Oracle, DB2: use the || operator. These dialects' CONCAT() function (where it exists at all) is limited to exactly 2 arguments (Oracle, DB2), so || is used uniformly for correctness with any number of parts. Postgres/CockroachDB/ SQLite treat || as the idiomatic concatenation operator.
Parameters
- dialect: Dialect
- ...parts: StringSqlExpr[]
  Column-like arguments (columns via col(), nested expressions via fn(), or literal string values as plain strings).
Returns LiteralExpression & { $literal: string }
- Defined in query-builders/functions/string.ts:126