Class LikeOperandSql
BR-7 (2026-09-02): the operand of the StartsWith/EndsWith/Contains sugar (+IgnoreCase) is a
LITERAL by contract - '%'/'_' must not act as LIKE wildcards, '[' must not open a T-SQL
character class, and a backslash must not act as the escape character. The Pro builders splice
the operand into the pattern inside SQL (col LIKE || '%'), so the escaping wraps the
operand expression in SQL too - deliberately with the engines' built-in replace() and
NOT the bundle's pvt_like_escape(): a Pro assembly must not require a bundle version
(deployment skew would turn every string search into an undefined-function error).
The ESCAPE clause is the call site's duty: PostgreSQL's default escape is already the
backslash; SQLite and MSSQL sites must append ESCAPE '\' themselves. The raw
$like/$ilike operators never pass through here - the pattern belongs to the caller.
public static class LikeOperandSql
Inheritance
Methods
MsSql(string)
Wraps an operand SQL expression for MSSQL LIKE.
public static string MsSql(string operandSql)
PgSqlite(string)
Wraps an operand SQL expression for PostgreSQL/SQLite LIKE.
public static string PgSqlite(string operandSql)