Enum QueryFilterOperator 

pub enum QueryFilterOperator {
    Equal,
    NotEqual,
    GreaterThan,
    GreaterOrEqual,
    LessThan,
    LessOrEqual,
    In,
    NotIn,
    IsNull,
    IsNotNull,
    Like,
    NotLike,
}

Represents SQL comparison operators for filtering.

These operators provide type-safe filtering capabilities beyond simple equality. All operators are validated and protected against SQL injection.

Security

• All operators use parameterized queries
• Column names are validated against the model struct
• Input values are bound as parameters, never concatenated

Examples

use sqlx_paginated::{QueryFilterOperator, QueryParamsBuilder};
use serde::Serialize;

#[derive(Serialize, Default)]
struct Product {
    price: f64,
    stock: i32,
    status: String,
}

let params = QueryParamsBuilder::<Product>::new()
    .with_filter_operator("price", QueryFilterOperator::GreaterThan, "10.00")
    .with_filter_operator("stock", QueryFilterOperator::LessOrEqual, "100")
    .with_filter_operator("status", QueryFilterOperator::NotEqual, "deleted")
    .build();

Variants

Equal

Equal to (=)

Example: age = 25

NotEqual

Not equal to (!= or <>)

Example: status != 'deleted'

GreaterThan

Greater than (>)

Example: price > 10.00

GreaterOrEqual

Greater than or equal to (>=)

Example: age >= 18

LessThan

Less than (<)

Example: stock < 10

LessOrEqual

Less than or equal to (<=)

Example: price <= 100.00

In

IN clause - value in a list

Values should be comma-separated strings. Example: status IN ('active', 'pending')

NotIn

NOT IN clause - value not in a list

Values should be comma-separated strings. Example: role NOT IN ('admin', 'moderator')

IsNull

IS NULL check

Example: deleted_at IS NULL

IsNotNull

IS NOT NULL check

Example: email IS NOT NULL

Like

LIKE pattern matching (case-insensitive)

Supports SQL wildcards: % (any characters) and _ (single character) Example: email LIKE '%@company.com'

NotLike

NOT LIKE pattern matching (case-insensitive)

Example: email NOT LIKE '%@spam.com'

Implementations

impl QueryFilterOperator

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

Returns the SQL representation of the operator.

pub fn requires_value(&self) -> bool

Returns true if the operator requires a value (excludes IS NULL/IS NOT NULL).

pub fn accepts_multiple_values(&self) -> bool

Returns true if the operator accepts multiple values (IN/NOT IN).

pub fn from_str(s: &str) -> Self

Parses an operator from a string representation.

Arguments

• s - String representation of the operator

Returns

Returns the corresponding QueryFilterOperator or defaults to Equal if not recognized.

Trait Implementations

impl Clone for QueryFilterOperator

fn clone(&self) -> QueryFilterOperator

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for QueryFilterOperator

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

Formats the value using the given formatter.

impl Default for QueryFilterOperator

fn default() -> QueryFilterOperator

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for QueryFilterOperator

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for QueryFilterOperator

fn eq(&self, other: &QueryFilterOperator) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for QueryFilterOperator

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for QueryFilterOperator