Enum SqlExpression 

pub enum SqlExpression {
    Column(ColumnRef),
    StringLiteral(String),
    NumberLiteral(String),
    BooleanLiteral(bool),
    Null,
    DateTimeConstructor {
        year: i32,
        month: u32,
        day: u32,
        hour: Option<u32>,
        minute: Option<u32>,
        second: Option<u32>,
    },
    DateTimeToday {
        hour: Option<u32>,
        minute: Option<u32>,
        second: Option<u32>,
    },
    MethodCall {
        object: String,
        method: String,
        args: Vec<SqlExpression>,
    },
    ChainedMethodCall {
        base: Box<SqlExpression>,
        method: String,
        args: Vec<SqlExpression>,
    },
    FunctionCall {
        name: String,
        args: Vec<SqlExpression>,
        distinct: bool,
    },
    WindowFunction {
        name: String,
        args: Vec<SqlExpression>,
        window_spec: WindowSpec,
    },
    BinaryOp {
        left: Box<SqlExpression>,
        op: String,
        right: Box<SqlExpression>,
    },
    InList {
        expr: Box<SqlExpression>,
        values: Vec<SqlExpression>,
    },
    NotInList {
        expr: Box<SqlExpression>,
        values: Vec<SqlExpression>,
    },
    Between {
        expr: Box<SqlExpression>,
        lower: Box<SqlExpression>,
        upper: Box<SqlExpression>,
    },
    Not {
        expr: Box<SqlExpression>,
    },
    CaseExpression {
        when_branches: Vec<WhenBranch>,
        else_branch: Option<Box<SqlExpression>>,
    },
    SimpleCaseExpression {
        expr: Box<SqlExpression>,
        when_branches: Vec<SimpleWhenBranch>,
        else_branch: Option<Box<SqlExpression>>,
    },
    ScalarSubquery {
        query: Box<SelectStatement>,
    },
    InSubquery {
        expr: Box<SqlExpression>,
        subquery: Box<SelectStatement>,
    },
    Unnest {
        column: Box<SqlExpression>,
        delimiter: String,
    },
    NotInSubquery {
        expr: Box<SqlExpression>,
        subquery: Box<SelectStatement>,
    },
    InSubqueryTuple {
        exprs: Vec<SqlExpression>,
        subquery: Box<SelectStatement>,
    },
    NotInSubqueryTuple {
        exprs: Vec<SqlExpression>,
        subquery: Box<SelectStatement>,
    },
}

Variants

Column(ColumnRef)

StringLiteral(String)

NumberLiteral(String)

BooleanLiteral(bool)

Null

DateTimeConstructor

Fields

year: i32

month: u32

day: u32

hour: Option<u32>

minute: Option<u32>

second: Option<u32>

DateTimeToday

Fields

hour: Option<u32>

minute: Option<u32>

second: Option<u32>

MethodCall

Fields

object: String

method: String

args: Vec<SqlExpression>

ChainedMethodCall

Fields

base: Box<SqlExpression>

method: String

args: Vec<SqlExpression>

FunctionCall

Fields

name: String

args: Vec<SqlExpression>

distinct: bool

WindowFunction

Fields

name: String

args: Vec<SqlExpression>

window_spec: WindowSpec

BinaryOp

Fields

left: Box<SqlExpression>

op: String

right: Box<SqlExpression>

InList

Fields

expr: Box<SqlExpression>

values: Vec<SqlExpression>

NotInList

Fields

expr: Box<SqlExpression>

values: Vec<SqlExpression>

Between

Fields

expr: Box<SqlExpression>

lower: Box<SqlExpression>

upper: Box<SqlExpression>

Not

Fields

expr: Box<SqlExpression>

CaseExpression

Fields

when_branches: Vec<WhenBranch>

else_branch: Option<Box<SqlExpression>>

SimpleCaseExpression

Fields

expr: Box<SqlExpression>

when_branches: Vec<SimpleWhenBranch>

else_branch: Option<Box<SqlExpression>>

ScalarSubquery

Scalar subquery that returns a single value Used in expressions like: WHERE col = (SELECT MAX(id) FROM table)

Fields

query: Box<SelectStatement>

InSubquery

IN subquery that returns multiple values Used in expressions like: WHERE col IN (SELECT id FROM table WHERE …)

Fields

expr: Box<SqlExpression>

subquery: Box<SelectStatement>

Unnest

UNNEST - Row expansion function that splits delimited strings Used like: SELECT UNNEST(accounts, ‘|’) AS account FROM fix_trades Causes row multiplication - one input row becomes N output rows

Fields

column: Box<SqlExpression>

delimiter: String

NotInSubquery

NOT IN subquery Used in expressions like: WHERE col NOT IN (SELECT id FROM table WHERE …)

Fields

expr: Box<SqlExpression>

subquery: Box<SelectStatement>

InSubqueryTuple

Tuple IN subquery — matches multiple columns at once Used in expressions like: WHERE (a, b) IN (SELECT x, y FROM table WHERE …) The subquery must return the same number of columns as the LHS tuple.

Fields

exprs: Vec<SqlExpression>

subquery: Box<SelectStatement>

NotInSubqueryTuple

Tuple NOT IN subquery Used in expressions like: WHERE (a, b) NOT IN (SELECT x, y FROM table WHERE …)

Fields

exprs: Vec<SqlExpression>

subquery: Box<SelectStatement>

Trait Implementations

impl Clone for SqlExpression

fn clone(&self) -> SqlExpression

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqlExpression

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

Formats the value using the given formatter.