Struct Select 

pub struct Select { /* private fields */ }

A select query builder.

Implementations

impl Select

pub fn col(self, name: impl Into<String>) -> Select

Project a column through unchanged.

pub fn cols<I, S>(self, names: I) -> Select

where I: IntoIterator<Item = S>, S: Into<String>,

Project several columns through unchanged.

pub fn agg(self, name: impl Into<String>, expr: Expr) -> Select

Add a named computed / aggregation column.

pub fn filter(self, predicate: Expr) -> Select

Add a where predicate (multiple predicates are AND-combined).

pub fn by(self, name: impl Into<String>) -> Select

Group by a column.

pub fn by_expr(self, name: impl Into<String>, expr: Expr) -> Select

Group by a named computed expression.

pub fn order_by<I, S>(self, cols: I, desc: bool) -> Select

where I: IntoIterator<Item = S>, S: Into<String>,

Order the result by columns (ascending unless desc).

pub fn execute(&self) -> Result<Table>

Compile, evaluate, and return the resulting table.