Enum SqlExpr 

pub enum SqlExpr {
    Column(String),
    Literal(Value),
    BinaryOp {
        left: Box<SqlExpr>,
        op: BinaryOp,
        right: Box<SqlExpr>,
    },
    Negate(Box<SqlExpr>),
    Function {
        name: String,
        args: Vec<SqlExpr>,
    },
    Cast {
        expr: Box<SqlExpr>,
        to_type: CastType,
    },
    Case {
        operand: Option<Box<SqlExpr>>,
        when_thens: Vec<(SqlExpr, SqlExpr)>,
        else_expr: Option<Box<SqlExpr>>,
    },
    Coalesce(Vec<SqlExpr>),
    NullIf(Box<SqlExpr>, Box<SqlExpr>),
    IsNull {
        expr: Box<SqlExpr>,
        negated: bool,
    },
    OldColumn(String),
    ExcludedColumn(String),
}

A serializable SQL expression that can be evaluated against a document.

Variants

Column(String)

Column reference: extract field value from the document.

Literal(Value)

Literal value.

BinaryOp

Binary operation: left op right.

Fields

left: Box<SqlExpr>

op: BinaryOp

right: Box<SqlExpr>

Negate(Box<SqlExpr>)

Unary negation: -expr or NOT expr.

Function

Scalar function call.

Fields

name: String

args: Vec<SqlExpr>

Cast

CAST(expr AS type).

Fields

expr: Box<SqlExpr>

to_type: CastType

Case

CASE WHEN cond1 THEN val1 … ELSE default END.

Fields

operand: Option<Box<SqlExpr>>

when_thens: Vec<(SqlExpr, SqlExpr)>

else_expr: Option<Box<SqlExpr>>

Coalesce(Vec<SqlExpr>)

COALESCE(expr1, expr2, …): first non-null value.

NullIf(Box<SqlExpr>, Box<SqlExpr>)

NULLIF(expr1, expr2): returns NULL if expr1 = expr2, else expr1.

IsNull

IS NULL / IS NOT NULL.

Fields

expr: Box<SqlExpr>

negated: bool

OldColumn(String)

OLD column reference: extract field value from the pre-update document. Used in TRANSITION CHECK predicates. Resolves against the OLD row when evaluated via eval_with_old(). Returns NULL in normal eval().

ExcludedColumn(String)

EXCLUDED.col reference from INSERT ... ON CONFLICT DO UPDATE: the column value from the row proposed for insertion that triggered the conflict. Resolves against the incoming row when evaluated via eval_with_excluded(). Returns NULL in plain eval() / eval_with_old().

Implementations

impl SqlExpr

pub fn eval(&self, doc: &Value) -> Value

Evaluate this expression against a document.

Column references look up fields in the document. Missing fields return Null. Arithmetic on non-numeric values returns Null. OldColumn(..) resolves to Null (use eval_with_old for the TRANSITION CHECK path).

pub fn eval_with_old(&self, new_doc: &Value, old_doc: &Value) -> Value

Evaluate with access to both NEW and OLD documents, used by TRANSITION CHECK predicates. Column(name) resolves against new_doc; OldColumn(name) resolves against old_doc.

pub fn eval_with_excluded(&self, doc: &Value, excluded: &Value) -> Value

Evaluate with access to the incoming EXCLUDED.* row, used by INSERT ... ON CONFLICT DO UPDATE. Column(name) resolves against the existing (current) row doc; ExcludedColumn(name) resolves against excluded.

Trait Implementations

impl Clone for SqlExpr

fn clone(&self) -> SqlExpr

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqlExpr

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for SqlExpr

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl<'a> FromMessagePack<'a> for SqlExpr

fn read<R: Read<'a>>(reader: &mut R) -> Result<Self>

Reads the MessagePack representation of this value from the provided reader.

impl PartialEq for SqlExpr

fn eq(&self, other: &SqlExpr) -> 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 SqlExpr

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl ToMessagePack for SqlExpr

fn write<W: Write>(&self, writer: &mut W) -> Result<()>

Writes the MessagePack representation of this value into the provided writer.

impl StructuralPartialEq for SqlExpr