Struct Query 

pub struct Query {
    pub with: Option<With>,
    pub body: Box<SetExpr>,
    pub order_by: Option<OrderBy>,
    pub limit_clause: Option<LimitClause>,
    pub fetch: Option<Fetch>,
    pub locks: Vec<LockClause>,
    pub for_clause: Option<ForClause>,
    pub settings: Option<Vec<Setting>>,
    pub format_clause: Option<FormatClause>,
    pub pipe_operators: Vec<PipeOperator>,
}

The most complete variant of a SELECT query expression, optionally including WITH, UNION / other set operations, and ORDER BY.

Fields

with: Option<With>

WITH (common table expressions, or CTEs)

body: Box<SetExpr>

SELECT or UNION / EXCEPT / INTERSECT

order_by: Option<OrderBy>

ORDER BY

limit_clause: Option<LimitClause>

LIMIT ... OFFSET ... | LIMIT <offset>, <limit>

fetch: Option<Fetch>

FETCH { FIRST | NEXT } <N> [ PERCENT ] { ROW | ROWS } | { ONLY | WITH TIES }

locks: Vec<LockClause>

FOR { UPDATE | SHARE } [ OF table_name ] [ SKIP LOCKED | NOWAIT ]

for_clause: Option<ForClause>

FOR XML { RAW | AUTO | EXPLICIT | PATH } [ , ELEMENTS ] FOR JSON { AUTO | PATH } [ , INCLUDE_NULL_VALUES ] (MSSQL-specific)

settings: Option<Vec<Setting>>

ClickHouse syntax: SELECT * FROM t SETTINGS key1 = value1, key2 = value2

ClickHouse

format_clause: Option<FormatClause>

SELECT * FROM t FORMAT JSONCompact

ClickHouse (ClickHouse-specific)

pipe_operators: Vec<PipeOperator>

Pipe operator

Trait Implementations

impl Clone for Query

fn clone(&self) -> Query

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Query

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

Formats the value using the given formatter.

impl Display for Query

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

Formats the value using the given formatter.

impl From<Query> for Statement

fn from(q: Query) -> Statement

Converts to this type from the input type.

impl Hash for Query

fn hash<__H>(&self, state: &mut __H)

where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for Query

fn cmp(&self, other: &Query) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for Query

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

fn partial_cmp(&self, other: &Query) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

Tests less than (for self and other) and is used by the < operator.

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

Tests less than or equal to (for self and other) and is used by the <= operator.

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

Tests greater than (for self and other) and is used by the > operator.

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

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Spanned for Query

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl Visit for Query

fn visit<V>(&self, visitor: &mut V) -> ControlFlow<<V as Visitor>::Break>

where V: Visitor,

impl VisitMut for Query

fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>

where V: VisitorMut,

impl Eq for Query

impl StructuralPartialEq for Query