Struct Select

pub struct Select<'a> { /* private fields */ }

SELECT

Implementations

impl<'a> Select<'a>

pub fn new(table: &'a str) -> Self

Construct a new SELECT query builder

pub fn alias(&mut self, table: &'a str, alias: &'a str) -> &mut Self

Set a table alias (AS)

pub fn fields(&mut self, fields: &[&'a str]) -> &mut Self

Specify desired table fields in result set

pub fn filter(&mut self, expr: &'a str) -> &mut Self

Filter result set based on conditions (WHERE clause)

pub fn group_by(&mut self, val: &'a str) -> &mut Self

Group result set based on common value (GROUP BY clause)

pub fn having(&mut self, expr: &'a str) -> &mut Self

Filter result set based on an expression on an aggregate value (HAVING clause)

pub fn order_by(&mut self, expr: &'a str, direction: Order) -> &mut Self

Order result set based on the value of an expression (ORDER BY clause)

pub fn join( &mut self, table: &'a str, on_left: &'a str, on_right: &'a str, kind: Join, ) -> &mut Self

pub fn limit(&mut self, limit: usize) -> &mut Self

Limit number of rows in result set (LIMIT)

pub fn offset(&mut self, offset: usize) -> &mut Self

Offset number of rows in result set (OFFSET)

pub fn build(&self) -> String

Generate SQL query (String) from subsequent method calls

Trait Implementations

impl<'a> Debug for Select<'a>

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

Formats the value using the given formatter.

impl<'a> Display for Select<'a>

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

Formats the value using the given formatter.