Struct QueryBuilder 

pub struct QueryBuilder<D: Dialect> { /* private fields */ }

SQL query builder with dialect support.

Implementations

impl<D: Dialect> QueryBuilder<D>

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

Create a new query builder for the given table.

Panics

Panics if the table name is not a valid SQL identifier.

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

Set the fields to SELECT.

Panics

Panics if any field name is not a valid SQL identifier.

pub fn computed( self, alias: impl Into<String>, expression: impl Into<String>, ) -> Self

Add a computed field to the SELECT clause.

Example

.computed("full_name", "first_name || ' ' || last_name")
.computed("line_total", "quantity * price")

Panics

Panics if alias is not a valid SQL identifier or expression contains dangerous patterns (comments, semicolons, SQL keywords).

Security

WARNING: Only use with trusted expressions from code, never with user input.

pub fn aggregate(self, agg: Aggregate) -> Self

Add an aggregation to the SELECT clause.

pub fn count(self) -> Self

Add a COUNT(*) aggregation.

pub fn sum(self, field: impl Into<String>) -> Self

Add a SUM(field) aggregation.

pub fn avg(self, field: impl Into<String>) -> Self

Add an AVG(field) aggregation.

pub fn min(self, field: impl Into<String>) -> Self

Add a MIN(field) aggregation.

pub fn max(self, field: impl Into<String>) -> Self

Add a MAX(field) aggregation.

pub fn filter( self, field: impl Into<String>, op: Operator, value: Value, ) -> Self

Add a filter condition.

Panics

Panics if the field name is not a valid SQL identifier.

pub fn filter_expr(self, expr: FilterExpr) -> Self

Set a compound filter expression (replaces simple filters for WHERE clause).

pub fn and(self, filters: Vec<FilterExpr>) -> Self

Add an AND compound filter.

pub fn or(self, filters: Vec<FilterExpr>) -> Self

Add an OR compound filter.

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

Add GROUP BY fields.

Panics

Panics if any field name is not a valid SQL identifier.

pub fn having(self, expr: FilterExpr) -> Self

Add a HAVING clause (for filtering aggregated results).

pub fn sort(self, field: impl Into<String>, dir: SortDir) -> Self

Add a sort field.

Panics

Panics if the field name is not a valid SQL identifier.

pub fn sorts(self, sorts: &[SortField]) -> Self

Add multiple sort fields.

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

Set pagination with page number (1-indexed) and limit.

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

Set explicit limit and offset.

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

Set a limit without offset.

pub fn after_cursor(self, cursor: impl IntoCursor) -> Self

Paginate after this cursor (forward pagination).

This method accepts flexible input types for great DX:

• &Cursor - when you have an already-parsed cursor
• &str - automatically decodes the base64 cursor
• Option<&str> - perfect for req.query("after") results

If the cursor is invalid or None, it’s silently ignored. This makes it safe to pass req.query("after") directly.

pub fn before_cursor(self, cursor: impl IntoCursor) -> Self

Paginate before this cursor (backward pagination).

This method accepts flexible input types for great DX:

• &Cursor - when you have an already-parsed cursor
• &str - automatically decodes the base64 cursor
• Option<&str> - perfect for req.query("before") results

If the cursor is invalid or None, it’s silently ignored.

pub fn build(self) -> QueryResult

Build the SQL query and parameters.

Trait Implementations

impl<D: Debug + Dialect> Debug for QueryBuilder<D>

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

Formats the value using the given formatter.