Struct SqlParts 

pub struct SqlParts {

    pub operation: SqlOperation,
    pub schema: String,
    pub table: String,
    pub select_columns: Option<String>,
    pub filters: Vec<FilterCondition>,
    pub orders: Vec<OrderClause>,
    pub limit: Option<i64>,
    pub offset: Option<i64>,
    pub single: bool,
    pub maybe_single: bool,
    pub count: CountOption,
    pub set_clauses: Vec<(String, usize)>,
    pub many_rows: Vec<Vec<(String, usize)>>,
    pub returning: Option<String>,
    pub conflict_columns: Vec<String>,
    pub conflict_constraint: Option<String>,
    pub ignore_duplicates: bool,
    pub schema_override: Option<String>,
    pub explain: Option<ExplainOptions>,
    pub head: bool,
}

Collects all the components of a SQL query being built.

Fields

operation: SqlOperation

schema: String

table: String

select_columns: Option<String>

Columns to select (None = *)

filters: Vec<FilterCondition>

Filter conditions (WHERE)

orders: Vec<OrderClause>

ORDER BY clauses

limit: Option<i64>

LIMIT

offset: Option<i64>

OFFSET (from range)

single: bool

Whether to return a single row (enforced at execution)

maybe_single: bool

Whether to return zero or one row

count: CountOption

Count option

set_clauses: Vec<(String, usize)>

Insert/Update column-value pairs: Vec<(column, param_index)>

many_rows: Vec<Vec<(String, usize)>>

For insert_many/upsert_many: Vec of rows, each is Vec<(column, param_index)>

returning: Option<String>

RETURNING columns (None = don’t return, Some(“*”) = all)

conflict_columns: Vec<String>

ON CONFLICT columns (for upsert)

conflict_constraint: Option<String>

ON CONFLICT constraint name (alternative to columns)

ignore_duplicates: bool

When true, upsert generates ON CONFLICT DO NOTHING instead of DO UPDATE

schema_override: Option<String>

Schema override for per-query schema qualification

explain: Option<ExplainOptions>

EXPLAIN options (only for SELECT)

head: bool

Head mode: SELECT count(*) only, no rows

Implementations

impl SqlParts

pub fn new( operation: SqlOperation, schema: impl Into<String>, table: impl Into<String>, ) -> SqlParts

pub fn qualified_table(&self) -> String

Get the fully-qualified table name, using schema_override if set.

Trait Implementations

impl Clone for SqlParts

fn clone(&self) -> SqlParts

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqlParts

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

Formats the value using the given formatter.