Struct SelectQuery 

pub struct SelectQuery { /* private fields */ }

A SELECT query builder.

Supports: WHERE, ORDER BY, LIMIT, OFFSET, DISTINCT, column selection.

Implementations

impl SelectQuery

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

Create a new SELECT query for the given table.

pub fn cols(self, columns: &[&str]) -> Self

Select specific columns instead of *.

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

Add a WHERE clause. Multiple calls replace (not append). Use .and() / .or() on Expr to compose filters.

pub fn order_by(self, order: OrderExpr) -> Self

Add an ORDER BY clause. Multiple calls append ordering.

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

Set the LIMIT.

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

Set the OFFSET.

pub fn distinct(self) -> Self

Add DISTINCT.

pub fn to_sql(&self) -> (String, Vec<Value>)

Render to SQL string + parameters.

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.