Struct Expr 

pub struct Expr { /* private fields */ }

A SQL expression (for WHERE, HAVING, etc.).

Implementations

impl Expr

pub fn from_fragment(fragment: SqlFragment) -> Self

Create an expression from a SQL fragment.

pub fn column(name: &str) -> Self

Create a column reference expression.

pub fn qualified_column(table: &str, column: &str) -> Self

Create a qualified column reference (table.column).

pub fn eq(column: &str, value: impl Into<SqlParam>) -> Self

Create an equality expression: column = $1

pub fn neq(column: &str, value: impl Into<SqlParam>) -> Self

Create a not-equal expression: column <> $1

pub fn gt(column: &str, value: impl Into<SqlParam>) -> Self

Create a greater-than expression: column > $1

pub fn gte(column: &str, value: impl Into<SqlParam>) -> Self

Create a greater-than-or-equal expression: column >= $1

pub fn lt(column: &str, value: impl Into<SqlParam>) -> Self

Create a less-than expression: column < $1

pub fn lte(column: &str, value: impl Into<SqlParam>) -> Self

Create a less-than-or-equal expression: column <= $1

pub fn like(column: &str, pattern: impl Into<SqlParam>) -> Self

Create a LIKE expression: column LIKE $1

pub fn ilike(column: &str, pattern: impl Into<SqlParam>) -> Self

Create an ILIKE expression: column ILIKE $1

pub fn is_null(column: &str) -> Self

Create an IS NULL expression: column IS NULL

pub fn is_not_null(column: &str) -> Self

Create an IS NOT NULL expression: column IS NOT NULL

pub fn in_list(column: &str, values: Vec<SqlParam>) -> Self

Create an IN expression: column IN ($1, $2, …)

pub fn contains(column: &str, value: impl Into<SqlParam>) -> Self

Create a contains expression: column @> $1

pub fn contained_by(column: &str, value: impl Into<SqlParam>) -> Self

Create a contained-by expression: column <@ $1

pub fn overlaps(column: &str, value: impl Into<SqlParam>) -> Self

Create an overlap expression: column && $1

pub fn fts( column: &str, query: impl Into<SqlParam>, language: Option<&str>, ) -> Self

Create a full-text search expression: column @@ to_tsquery($1)

pub fn not(self) -> Self

Negate this expression: NOT (expr)

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

Combine with AND: self AND other

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

Combine with OR: self OR other

pub fn and_all(exprs: impl IntoIterator<Item = Expr>) -> Self

Combine multiple expressions with AND.

pub fn or_all(exprs: impl IntoIterator<Item = Expr>) -> Self

Combine multiple expressions with OR.

pub fn into_fragment(self) -> SqlFragment

Convert to a SQL fragment.

pub fn sql(&self) -> &str

Get the SQL string.

pub fn params(&self) -> &[SqlParam]

Get the parameters.

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.