Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

安全的查询构建器，使用绑定参数而非字符串拼接

Implementations

impl QueryBuilder

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

pub fn with_base_sql(self, base_sql: impl Into<String>) -> Self

替换基础 SQL（保留已有的条件、排序和绑定）

pub fn limit(self, n: u64) -> Self

设置 LIMIT（链式调用），仅作用于 into_sql 生成的 SQL

pub fn offset(self, n: u64) -> Self

设置 OFFSET（链式调用），仅作用于 into_sql 生成的 SQL

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

添加 GROUP BY 字段（链式调用，可多次调用添加多个字段）

pub fn having_eq(self, field: &str, value: impl Into<BindValue>) -> Self

HAVING 条件：等于

pub fn having_ne(self, field: &str, value: impl Into<BindValue>) -> Self

HAVING 条件：不等于

pub fn having_gt(self, field: &str, value: impl Into<BindValue>) -> Self

HAVING 条件：大于

pub fn having_ge(self, field: &str, value: impl Into<BindValue>) -> Self

HAVING 条件：大于等于

pub fn having_lt(self, field: &str, value: impl Into<BindValue>) -> Self

HAVING 条件：小于

pub fn having_le(self, field: &str, value: impl Into<BindValue>) -> Self

HAVING 条件：小于等于

pub fn and_eq(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn and_ne(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn and_gt(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn and_ge(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn and_lt(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn and_le(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn or_eq(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn or_ne(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn or_gt(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn or_ge(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn or_lt(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn or_le(self, field: &str, value: impl Into<BindValue>) -> Self

pub fn and_like(self, field: &str, value: impl Into<String>) -> Self

pub fn and_like_prefix(self, field: &str, value: impl Into<String>) -> Self

LIKE 前缀匹配（value%）

pub fn and_like_suffix(self, field: &str, value: impl Into<String>) -> Self

LIKE 后缀匹配（%value）

pub fn and_like_exact(self, field: &str, value: impl Into<String>) -> Self

LIKE 精确匹配（不添加 %）

pub fn and_like_custom(self, field: &str, pattern: impl Into<String>) -> Self

LIKE 自定义模式匹配

pub fn or_like(self, field: &str, value: impl Into<String>) -> Self

pub fn and_regexp(self, field: &str, pattern: impl Into<String>) -> Self

正则表达式匹配（AND 条件） MySQL: field REGEXP pattern PostgreSQL: field ~ pattern SQLite: 不支持原生正则表达式（会抛出错误）

pub fn or_regexp(self, field: &str, pattern: impl Into<String>) -> Self

正则表达式匹配（OR 条件） MySQL: field REGEXP pattern PostgreSQL: field ~ pattern SQLite: 不支持原生正则表达式（会抛出错误）

pub fn and_in(self, field: &str, values: Vec<impl Into<BindValue>>) -> Self

pub fn and_not_in(self, field: &str, values: Vec<impl Into<BindValue>>) -> Self

NOT IN 查询

pub fn or_in(self, field: &str, values: Vec<impl Into<BindValue>>) -> Self

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

IS NULL 查询

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

IS NOT NULL 查询

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

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

pub fn and_between( self, field: &str, min: impl Into<BindValue>, max: impl Into<BindValue>, ) -> Self

BETWEEN 范围查询

pub fn or_between( self, field: &str, min: impl Into<BindValue>, max: impl Into<BindValue>, ) -> Self

pub fn and_group<F>(self, f: F) -> Self

where F: FnOnce(QueryBuilder) -> QueryBuilder,

AND 条件分组：创建一个用 AND 连接的条件组 示例：builder.and_group(|b| b.and_eq("a", 1).and_eq("b", 2)) 生成：(a = ? AND b = ?)

pub fn or_group<F>(self, f: F) -> Self

where F: FnOnce(QueryBuilder) -> QueryBuilder,

OR 条件分组：创建一个用 OR 连接的条件组 示例：builder.or_group(|b| b.and_eq("c", 3).and_eq("d", 4)) 生成：(c = ? OR d = ?)

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

pub fn into_sql(&self, driver: DbDriver) -> String

pub fn into_count_sql(&self, driver: DbDriver) -> String

pub fn into_paginated_sql( &self, driver: DbDriver, limit: u64, offset: u64, ) -> String

pub fn binds(&self) -> Vec<BindValue>

返回所有绑定值（WHERE 条件 + HAVING 条件）

Trait Implementations

impl Clone for QueryBuilder

fn clone(&self) -> QueryBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for QueryBuilder

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

Formats the value using the given formatter.