Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

Simple SQL query builder for common patterns

Example

let (sql, count_sql) = QueryBuilder::select("article")
    .columns("a.id, a.title, a.status, a.created")
    .alias("a")
    .join("LEFT JOIN user u ON a.user_id = u.id")
    .where_clause("a.status = 'published'")
    .search_columns(&["a.title", "a.content"])
    .paginate(&params);

Implementations

impl QueryBuilder

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

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

pub fn alias(self, alias: &str) -> Self

pub fn join(self, join: &str) -> Self

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

pub fn where_if(self, condition: &str, apply: bool) -> Self

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

pub fn group_by(self, clause: &str) -> Self

pub fn paginate(&self, params: &PaginationParams) -> (String, String)

Build SELECT + COUNT queries for pagination

Returns (data_query, count_query) Search params are bound separately by the caller