Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

SQL query builder with parameterized queries and JOIN support

Implementations

impl QueryBuilder

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

pub fn select(self, fields: &[&str]) -> Self

Select specific fields

pub fn where_eq(self, field: &str, value: QueryValue) -> Self

Add WHERE field = ? condition (parameterized)

pub fn where_ne(self, field: &str, value: QueryValue) -> Self

Add WHERE field != ? condition (parameterized)

pub fn where_gt(self, field: &str, value: QueryValue) -> Self

Add WHERE field > ? condition (parameterized)

pub fn where_lt(self, field: &str, value: QueryValue) -> Self

Add WHERE field < ? condition (parameterized)

pub fn where_like(self, field: &str, value: QueryValue) -> Self

Add WHERE field LIKE ? condition (parameterized)

pub fn where_in(self, field: &str, values: Vec<QueryValue>) -> Self

Add WHERE field IN (?) condition (parameterized)

pub fn join(self, join_type: JoinType, table: &str, on_condition: &str) -> Self

Add JOIN clause

pub fn join_alias( self, join_type: JoinType, table: &str, alias: &str, on_condition: &str, ) -> Self

Add JOIN clause with table alias

pub fn where_raw(self, condition: &str, param: QueryValue) -> Self

Add raw WHERE condition (for complex conditions)

pub fn order_by(self, field: &str, direction: &str) -> Self

Add ORDER BY clause

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

Add LIMIT clause

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

Add OFFSET clause

pub fn build_sql(&self) -> String

Build the SQL query string

pub fn build_query(&self) -> (String, Vec<QueryValue>)

Build query with parameters for execution

pub async fn execute<T>(&self, pool: &PgPool) -> Result<Vec<T>>

where T: for<'r> FromRow<'r, PgRow> + Send + Unpin,

Execute query and map results to a struct

pub async fn execute_first<T>(&self, pool: &PgPool) -> Result<Option<T>>

where T: for<'r> FromRow<'r, PgRow> + Send + Unpin,

Execute query and return first result