Struct SelectBuilder 

pub struct SelectBuilder { /* private fields */ }

SELECT query builder

Implementations

impl SelectBuilder

pub fn new(table: impl Into<String>) -> Self

Create a new SELECT query builder

pub fn select(self, columns: Vec<impl Into<String>>) -> Self

Select specific columns

pub fn select_all(self) -> Self

Select all columns

pub fn add_column(self, column: impl Into<String>) -> Self

Add a column to select

pub fn aggregate( self, func: AggregateFunc, column: impl Into<String>, alias: Option<impl Into<String>>, ) -> Self

Add an aggregate function

pub fn distinct(self) -> Self

Use DISTINCT

pub fn where_clause(self, condition: Condition) -> Self

Add a WHERE condition

pub fn and_where(self, condition: Condition) -> Self

Add an AND condition to existing WHERE

pub fn or_where(self, condition: Condition) -> Self

Add an OR condition to existing WHERE

pub fn where_eq(self, column: impl Into<String>, value: Value) -> Self

Add a simple WHERE condition (column = value)

pub fn where_gt(self, column: impl Into<String>, value: Value) -> Self

Add a WHERE column > value condition

pub fn where_lt(self, column: impl Into<String>, value: Value) -> Self

Add a WHERE column < value condition

pub fn where_in(self, column: impl Into<String>, values: Vec<Value>) -> Self

Add a WHERE column IN (…) condition

pub fn where_null(self, column: impl Into<String>) -> Self

Add a WHERE column IS NULL condition

pub fn where_like( self, column: impl Into<String>, pattern: impl Into<String>, ) -> Self

Add a WHERE column LIKE pattern condition

pub fn join( self, join_type: JoinType, table: impl Into<String>, on: Condition, ) -> Self

Add a JOIN clause

pub fn inner_join(self, table: impl Into<String>, on: Condition) -> Self

Add an INNER JOIN

pub fn left_join(self, table: impl Into<String>, on: Condition) -> Self

Add a LEFT JOIN

pub fn group_by(self, columns: Vec<impl Into<String>>) -> Self

Add GROUP BY columns

pub fn having(self, condition: Condition) -> Self

Add a HAVING condition

pub fn order_by( self, column: impl Into<String>, direction: SortDirection, ) -> Self

Add ORDER BY

pub fn order_asc(self, column: impl Into<String>) -> Self

Add ascending ORDER BY

pub fn order_desc(self, column: impl Into<String>) -> Self

Add descending ORDER BY

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

Set LIMIT

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

Set OFFSET

pub fn build(self) -> Result<String>

Build the SQL query string

pub fn to_sql(self) -> Result<String>

Build and return the SQL query string (convenience method)

Trait Implementations

impl Clone for SelectBuilder

fn clone(&self) -> SelectBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SelectBuilder

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

Formats the value using the given formatter.