Struct WhereBuilder 

pub struct WhereBuilder<D: Dialect> { /* private fields */ }

Accumulator passed to and_where/or_where closures.

It owns its own Vec<Predicate>; the closure consumes it and returns it, and the caller wraps the collected predicates into a Predicate::Group. The PhantomData<D> keeps the dialect in scope without threading the full builder through the closure.

Siblings added directly are AND-joined; call and_where/or_where inside the closure to nest a further parenthesized group (and or_where introduces OR within the group). Nesting is arbitrary-depth.

Implementations

impl<D: Dialect> WhereBuilder<D>

pub fn new() -> Self

Create an empty accumulator.

pub fn and_where( self, f: impl FnOnce(WhereBuilder<D>) -> WhereBuilder<D>, ) -> Self

Add a nested parenthesized AND (...) group built by the closure.

pub fn or_where( self, f: impl FnOnce(WhereBuilder<D>) -> WhereBuilder<D>, ) -> Self

Add a nested parenthesized OR (...) group built by the closure.

pub fn where_eq(self, col: &str, val: impl IntoBind) -> Self

col = val.

pub fn where_ne(self, col: &str, val: impl IntoBind) -> Self

col != val.

pub fn where_gt(self, col: &str, val: impl IntoBind) -> Self

col > val.

pub fn where_gte(self, col: &str, val: impl IntoBind) -> Self

col >= val.

pub fn where_lt(self, col: &str, val: impl IntoBind) -> Self

col < val.

pub fn where_lte(self, col: &str, val: impl IntoBind) -> Self

col <= val.

pub fn where_like(self, col: &str, val: impl IntoBind) -> Self

col LIKE val.

pub fn where_ilike(self, col: &str, val: impl IntoBind) -> Self

col ILIKE val — dialect-aware case-insensitive match (see QueryBuilder::where_ilike).

pub fn where_jsonb_contains(self, col: &str, val: impl IntoBind) -> Self

col @> val — JSONB containment (Postgres-oriented; see QueryBuilder::where_jsonb_contains).

pub fn where_in( self, col: &str, vals: impl IntoIterator<Item = impl IntoBind>, ) -> Self

col IN (...).

pub fn where_not_in( self, col: &str, vals: impl IntoIterator<Item = impl IntoBind>, ) -> Self

col NOT IN (...).

pub fn where_null(self, col: &str) -> Self

col IS NULL.

pub fn where_not_null(self, col: &str) -> Self

col IS NOT NULL.

pub fn where_between( self, col: &str, lo: impl IntoBind, hi: impl IntoBind, ) -> Self

col BETWEEN lo AND hi.

pub fn where_raw(self, sql: &str, binds: Vec<Value>) -> Self

Raw SQL predicate with its own binds — the verbatim escape hatch.

Warning: positional placeholder contract

sql is emitted verbatim (it is NOT escaped or renumbered) and binds are appended to the running bind list in order. For Postgres, the caller MUST write $N numbers matching the actual bind position — that is, number of binds already accumulated + 1, +2, … For MySQL/SQLite use ?. No renumbering is performed, so a wrong $N produces a malformed query.

pub fn where_column(self, lhs: &str, op: &'static str, rhs: &str) -> Self

lhs op rhs — compare two column identifiers (both escaped at compile time), no bind. See QueryBuilder::where_column.

Trait Implementations

impl<D: Dialect> Default for WhereBuilder<D>

fn default() -> Self

Returns the “default value” for a type.