Struct Expr 

pub struct Expr(pub Expression);

A thin wrapper around Expression that provides fluent operator methods.

Expr is the primary value type flowing through the builder API. It wraps a single AST Expression node and adds convenience methods for comparisons (.eq(), .gt(), etc.), logical connectives (.and(), .or(), .not()), arithmetic (.add(), .sub(), .mul(), .div()), pattern matching (.like(), .ilike(), .rlike()), and other SQL operations (.in_list(), .between(), .is_null(), .alias(), .cast(), .asc(), .desc()).

The inner Expression is publicly accessible via the .0 field or Expr::into_inner().

Examples

use polyglot_sql::builder::*;

let condition = col("age").gte(lit(18)).and(col("active").eq(boolean(true)));
assert_eq!(condition.to_sql(), "age >= 18 AND active = TRUE");

Tuple Fields

0: Expression

Implementations

impl Expr

pub fn into_inner(self) -> Expression

Consume this wrapper and return the inner Expression node.

pub fn to_sql(&self) -> String

Generate a SQL string from this expression using the default (generic) dialect.

Returns an empty string if generation fails.

pub fn eq(self, other: Expr) -> Expr

Produce a self = other equality comparison.

pub fn neq(self, other: Expr) -> Expr

Produce a self <> other inequality comparison.

pub fn lt(self, other: Expr) -> Expr

Produce a self < other less-than comparison.

pub fn lte(self, other: Expr) -> Expr

Produce a self <= other less-than-or-equal comparison.

pub fn gt(self, other: Expr) -> Expr

Produce a self > other greater-than comparison.

pub fn gte(self, other: Expr) -> Expr

Produce a self >= other greater-than-or-equal comparison.

pub fn and(self, other: Expr) -> Expr

Produce a self AND other logical conjunction.

pub fn or(self, other: Expr) -> Expr

Produce a self OR other logical disjunction.

pub fn not(self) -> Expr

Produce a NOT self logical negation.

pub fn xor(self, other: Expr) -> Expr

Produce a self XOR other logical exclusive-or.

pub fn add(self, other: Expr) -> Expr

Produce a self + other addition expression.

pub fn sub(self, other: Expr) -> Expr

Produce a self - other subtraction expression.

pub fn mul(self, other: Expr) -> Expr

Produce a self * other multiplication expression.

pub fn div(self, other: Expr) -> Expr

Produce a self / other division expression.

pub fn is_null(self) -> Expr

Produce a self IS NULL predicate.

pub fn is_not_null(self) -> Expr

Produce a self IS NOT NULL predicate (implemented as NOT (self IS NULL)).

pub fn in_list(self, values: impl IntoIterator<Item = Expr>) -> Expr

Produce a self IN (values...) membership test.

Each element of values becomes an item in the parenthesized list.

pub fn between(self, low: Expr, high: Expr) -> Expr

Produce a self BETWEEN low AND high range test.

pub fn like(self, pattern: Expr) -> Expr

Produce a self LIKE pattern case-sensitive pattern match.

pub fn alias(self, name: &str) -> Expr

Produce a self AS alias expression alias.

pub fn cast(self, to: &str) -> Expr

Produce a CAST(self AS type) type conversion.

The to parameter is parsed as a data type name; see cast() for details.

pub fn asc(self) -> Expr

Wrap this expression with ascending sort order (self ASC).

Used in ORDER BY clauses. Expressions without an explicit .asc() or .desc() call default to ascending order when passed to SelectBuilder::order_by().

pub fn desc(self) -> Expr

Wrap this expression with descending sort order (self DESC).

Used in ORDER BY clauses.

pub fn ilike(self, pattern: Expr) -> Expr

Produce a self ILIKE pattern case-insensitive pattern match.

Supported by PostgreSQL, Snowflake, and other dialects. Dialects that do not support ILIKE natively may need transpilation.

pub fn rlike(self, pattern: Expr) -> Expr

Produce a REGEXP_LIKE(self, pattern) regular expression match.

The generated SQL uses the REGEXP_LIKE function form. Different dialects may render this as RLIKE, REGEXP, or REGEXP_LIKE after transpilation.

pub fn not_in(self, values: impl IntoIterator<Item = Expr>) -> Expr

Produce a self NOT IN (values...) negated membership test.

Each element of values becomes an item in the parenthesized list.

Trait Implementations

impl Clone for Expr

fn clone(&self) -> Expr

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Expr

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl IntoExpr for Expr

fn into_expr(self) -> Expr

Convert this value into an Expr.