Small SQL-like expression engine for ETL derived columns, conditional splits, filters, and custom data-quality rules. Supports: literals (number/string/TRUE/FALSE/NULL), column references ([Column], "Column", `Column`, or bare identifiers), arithmetic (+ - * / %), comparisons (= == != <> < <= > >=), logical operators (AND OR NOT), IS NULL / IS NOT NULL, LIKE, and a built-in function library. Unknown columns evaluate to null.

Members

MemberKindDescription
static IReadOnlyCollection<string> FunctionsPropertyGets the names of all built-in functions.
object Evaluate(string expression, IDictionary<string, object> row)MethodEvaluates an expression against a row. Returns null when the result is NULL.
bool EvaluateBoolean(string expression, IDictionary<string, object> row)MethodEvaluates an expression as a boolean (null/0/empty/"false" are false).
IReadOnlyCollection<string> GetReferencedColumns(string expression)MethodReturns the column names referenced by the expression (excluding function names).

Related