Struct SelectQuery 

pub struct SelectQuery {
    pub distinct: bool,
    pub targets: Vec<Target>,
    pub from: Option<FromClause>,
    pub where_clause: Option<Expr>,
    pub group_by: Option<Vec<Expr>>,
    pub having: Option<Expr>,
    pub pivot_by: Option<Vec<Expr>>,
    pub order_by: Option<Vec<OrderSpec>>,
    pub limit: Option<u64>,
}

A SELECT query.

Fields

distinct: bool

Whether DISTINCT was specified.

targets: Vec<Target>

Target columns/expressions.

from: Option<FromClause>

FROM clause (transaction-level filtering).

where_clause: Option<Expr>

WHERE clause (posting-level filtering).

group_by: Option<Vec<Expr>>

GROUP BY clause.

having: Option<Expr>

HAVING clause (filter on aggregated results).

pivot_by: Option<Vec<Expr>>

PIVOT BY clause (pivot table transformation).

order_by: Option<Vec<OrderSpec>>

ORDER BY clause.

limit: Option<u64>

LIMIT clause.

Implementations

impl SelectQuery

pub const fn new(targets: Vec<Target>) -> Self

Create a new SELECT query with the given targets.

pub const fn distinct(self) -> Self

Set the DISTINCT flag.

pub fn from(self, from: FromClause) -> Self

Set the FROM clause.

pub fn where_clause(self, expr: Expr) -> Self

Set the WHERE clause.

pub fn group_by(self, exprs: Vec<Expr>) -> Self

Set the GROUP BY clause.

pub fn having(self, expr: Expr) -> Self

Set the HAVING clause.

pub fn pivot_by(self, exprs: Vec<Expr>) -> Self

Set the PIVOT BY clause.

pub fn order_by(self, specs: Vec<OrderSpec>) -> Self

Set the ORDER BY clause.

pub const fn limit(self, n: u64) -> Self

Set the LIMIT.

Trait Implementations

impl Clone for SelectQuery

fn clone(&self) -> SelectQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SelectQuery

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

Formats the value using the given formatter.

impl PartialEq for SelectQuery

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