Struct Query

pub struct Query {
    pub with: Option<With>,
    pub body: SetExpr,
    pub order_by: Vec<OrderByExpr>,
    pub limit: Option<String>,
    pub offset: Option<String>,
    pub fetch: Option<Fetch>,
}

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: SetExpr

SELECT or UNION / EXCEPT / INTERSECT

order_by: Vec<OrderByExpr>

ORDER BY

limit: Option<String>

LIMIT { <N> | ALL }

offset: Option<String>

OFFSET <N> [ { ROW | ROWS } ]

ROW and ROWS are noise words that don’t influence the effect of the clause. They are provided for ANSI compatibility.

fetch: Option<Fetch>

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

ROW and ROWS as well as FIRST and NEXT are noise words that don’t influence the effect of the clause. They are provided for ANSI compatibility.

Implementations

impl Query

pub fn as_simple_values(&self) -> Option<&Values>

Simple VALUES without other clauses.

Trait Implementations

impl Clone for Query

fn clone(&self) -> Query

Returns a copy 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

Formats the value using the given formatter.

impl Display for Query

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

Formats the value using the given formatter.

impl Hash for Query

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

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 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 Eq for Query

impl StructuralPartialEq for Query