Struct QueryBuilder 

pub struct QueryBuilder<M> { /* private fields */ }

A type-safe SQL query builder.

Constructed primarily via <Model>::find() and <Model>::select(...). Chain methods like .filter(), .order_by(), and .limit() before executing.

Implementations

impl<M: Model + Send + Sync> QueryBuilder<M>

pub fn new() -> Self

pub fn filter<E>(self, expr: E) -> Self

where E: IntoExpr<M>,

Add a WHERE filter clause, e.g., filter(Expr::new(“age >= {}”, vec![18.to_param()])) Or using DSL: filter(UserColumn::Age.gte(18.to_param())) Backwards compatibility raw signature with $1 etc is also supported if string literal passes without {}

pub fn select_only<E: IntoExpr<M>>(self, exprs: Vec<E>) -> Self

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

pub fn join_child<R: Model + HasForeignKey<M>>(self) -> Self

Adds an INNER JOIN automatically resolving foreign keys using HasForeignKey.

pub fn join_parent<R: Model>(self) -> Self

where M: HasForeignKey<R>,

Adds an INNER JOIN automatically resolving the parent entity foreign keys.

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

pub fn having<E: IntoExpr<M>>(self, expr: E) -> Self

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

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

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

pub fn into_raw(self, executor: &mut impl Executor) -> OrmResult<Vec<Row>>

Executes the query and returns raw Row results without model mapping.

pub fn all(self, executor: &mut impl Executor) -> OrmResult<Vec<M>>

Executes the query and returns a list of models.

pub fn paginate(self, page_size: usize) -> Paginator<M>

Converts this query builder into a Paginator using the specified page size.

pub fn one(self, executor: &mut impl Executor) -> OrmResult<Option<M>>

Executes the query, returning the first matching model, or None if not found.

pub fn count(self, executor: &mut impl Executor) -> OrmResult<i64>

Executes a COUNT(*) query for the current filters.

Trait Implementations

impl<M> Clone for QueryBuilder<M>

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<M: Model + Send + Sync> Default for QueryBuilder<M>

fn default() -> Self

Returns the “default value” for a type.