Enum WhereOperator 

pub enum WhereOperator {
    Eq(Field, Value),
    Neq(Field, Value),
    Gt(Field, Value),
    Gte(Field, Value),
    Lt(Field, Value),
    Lte(Field, Value),
    In(Field, Vec<Value>),
    Nin(Field, Vec<Value>),
    Contains(Field, String),
    ArrayContains(Field, Value),
    ArrayContainedBy(Field, Value),
    ArrayOverlaps(Field, Vec<Value>),
    LenEq(Field, usize),
    LenGt(Field, usize),
    LenGte(Field, usize),
    LenLt(Field, usize),
    LenLte(Field, usize),
    Icontains(Field, String),
    Startswith(Field, String),
    Endswith(Field, String),
    Like(Field, String),
    Ilike(Field, String),
    IsNull(Field, bool),
    L2Distance {
        field: Field,
        vector: Vec<f32>,
        threshold: f32,
    },
    CosineDistance {
        field: Field,
        vector: Vec<f32>,
        threshold: f32,
    },
    InnerProduct {
        field: Field,
        vector: Vec<f32>,
        threshold: f32,
    },
    JaccardDistance {
        field: Field,
        set: Vec<String>,
        threshold: f32,
    },
    Matches {
        field: Field,
        query: String,
        language: Option<String>,
    },
    PlainQuery {
        field: Field,
        query: String,
    },
    PhraseQuery {
        field: Field,
        query: String,
        language: Option<String>,
    },
    WebsearchQuery {
        field: Field,
        query: String,
        language: Option<String>,
    },
    IsIPv4(Field),
    IsIPv6(Field),
    IsPrivate(Field),
    IsLoopback(Field),
    InSubnet {
        field: Field,
        subnet: String,
    },
    ContainsSubnet {
        field: Field,
        subnet: String,
    },
    ContainsIP {
        field: Field,
        ip: String,
    },
    IPRangeOverlap {
        field: Field,
        range: String,
    },
}

WHERE clause operators

Supports type-safe, audit-friendly WHERE clause construction without raw SQL strings.

Categories

• Comparison: Eq, Neq, Gt, Gte, Lt, Lte
• Array: In, Nin, Contains, ArrayContains, ArrayContainedBy, ArrayOverlaps
• Array Length: LenEq, LenGt, LenGte, LenLt, LenLte
• String: Icontains, Startswith, Endswith, Like, Ilike
• Null: IsNull
• Vector Distance: L2Distance, CosineDistance, InnerProduct, JaccardDistance
• Full-Text Search: Matches, PlainQuery, PhraseQuery, WebsearchQuery
• Network: IsIPv4, IsIPv6, IsPrivate, IsLoopback, InSubnet, ContainsSubnet, ContainsIP, IPRangeOverlap

Variants

Eq(Field, Value)

Equal: field = value

Neq(Field, Value)

Not equal: field != value or field <> value

Gt(Field, Value)

Greater than: field > value

Gte(Field, Value)

Greater than or equal: field >= value

Lt(Field, Value)

Less than: field < value

Lte(Field, Value)

Less than or equal: field <= value

In(Field, Vec<Value>)

Array contains value: field IN (...)

Nin(Field, Vec<Value>)

Array does not contain value: field NOT IN (...)

Contains(Field, String)

String contains substring: field LIKE '%substring%'

ArrayContains(Field, Value)

Array contains element: PostgreSQL array operator @> Generated SQL: field @> array[value]

ArrayContainedBy(Field, Value)

Array is contained by: PostgreSQL array operator <@ Generated SQL: field <@ array[value]

ArrayOverlaps(Field, Vec<Value>)

Arrays overlap: PostgreSQL array operator && Generated SQL: field && array[value]

LenEq(Field, usize)

Array length equals: array_length(field, 1) = value

LenGt(Field, usize)

Array length greater than: array_length(field, 1) > value

LenGte(Field, usize)

Array length greater than or equal: array_length(field, 1) >= value

LenLt(Field, usize)

Array length less than: array_length(field, 1) < value

LenLte(Field, usize)

Array length less than or equal: array_length(field, 1) <= value

Icontains(Field, String)

Case-insensitive contains: field ILIKE '%substring%'

Startswith(Field, String)

Starts with: field LIKE 'prefix%'

Endswith(Field, String)

Ends with: field LIKE '%suffix'

Like(Field, String)

LIKE pattern matching: field LIKE pattern

Ilike(Field, String)

Case-insensitive LIKE: field ILIKE pattern

IsNull(Field, bool)

IS NULL: field IS NULL or field IS NOT NULL

When the boolean is true, generates IS NULL When false, generates IS NOT NULL

L2Distance

L2 (Euclidean) distance: l2_distance(field, vector) < threshold

Requires pgvector extension.

Fields

field: Field

The vector field to compare against

vector: Vec<f32>

The embedding vector for distance calculation

threshold: f32

Distance threshold for comparison

CosineDistance

Cosine distance: cosine_distance(field, vector) < threshold

Requires pgvector extension.

Fields

field: Field

The vector field to compare against

vector: Vec<f32>

The embedding vector for distance calculation

threshold: f32

Distance threshold for comparison

InnerProduct

Inner product: inner_product(field, vector) > threshold

Requires pgvector extension.

Fields

field: Field

The vector field to compare against

vector: Vec<f32>

The embedding vector for distance calculation

threshold: f32

Distance threshold for comparison

JaccardDistance

Jaccard distance: jaccard_distance(field, set) < threshold

Works with text arrays, measures set overlap.

Fields

field: Field

The field to compare against

set: Vec<String>

The set of values for comparison

threshold: f32

Distance threshold for comparison

Matches

Full-text search with language: field @@ plainto_tsquery(language, query)

If language is None, defaults to ‘english’

Fields

field: Field

The text field to search

query: String

The search query

language: Option<String>

Optional language for text search (default: english)

PlainQuery

Plain text query: field @@ plainto_tsquery(query)

Uses no language specification

Fields

field: Field

The text field to search

query: String

The search query

PhraseQuery

Phrase query with language: field @@ phraseto_tsquery(language, query)

If language is None, defaults to ‘english’

Fields

field: Field

The text field to search

query: String

The search query

language: Option<String>

Optional language for text search (default: english)

WebsearchQuery

Web search query with language: field @@ websearch_to_tsquery(language, query)

If language is None, defaults to ‘english’

Fields

field: Field

The text field to search

query: String

The search query

language: Option<String>

Optional language for text search (default: english)

IsIPv4(Field)

Check if IP is IPv4: family(field) = 4

IsIPv6(Field)

Check if IP is IPv6: family(field) = 6

IsPrivate(Field)

Check if IP is private (RFC1918): matches private ranges

IsLoopback(Field)

Check if IP is loopback: IPv4 127.0.0.0/8 or IPv6 ::1/128

InSubnet

IP is in subnet: field << subnet

The subnet should be in CIDR notation (e.g., “192.168.0.0/24”)

Fields

field: Field

The IP field to check

subnet: String

The CIDR subnet (e.g., “192.168.0.0/24”)

ContainsSubnet

Network contains subnet: field >> subnet

The subnet should be in CIDR notation

Fields

field: Field

The network field to check

subnet: String

The CIDR subnet to check for containment

ContainsIP

Network/range contains IP: field >> ip

The IP should be a single address (e.g., “192.168.1.1”)

Fields

field: Field

The network field to check

ip: String

The IP address to check for containment

IPRangeOverlap

IP ranges overlap: field && range

The range should be in CIDR notation

Fields

field: Field

The IP range field to check

range: String

The IP range to check for overlap

Implementations

impl WhereOperator

pub fn name(&self) -> &'static str

Get a human-readable name for this operator

pub fn validate(&self) -> Result<(), String>

Validate operator for basic correctness

Trait Implementations

impl Clone for WhereOperator

fn clone(&self) -> WhereOperator

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for WhereOperator

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

Formats the value using the given formatter.