Struct Db 

pub struct Db { /* private fields */ }

快捷查询入口（think-orm Db::name() 风格）

不要求定义 Model，仅靠表名 + 方言即可生成 SQL。

Implementations

impl Db

pub fn new(dialect: Box<dyn Dialect>) -> Db

创建快捷查询入口

pub fn name(self, table: impl Into<String>) -> Db

指定表名（等价于 think-orm 的 Db::name('user')）

pub fn select(self, columns: Vec<&str>) -> Db

选择列

pub fn where_cond(self, condition: impl Into<String>) -> Db

👎Deprecated since 1.3.0:

P0-2: 字符串拼接存在 SQL 注入风险，请使用 where_eq/where_ne/where_gt/where_lt/where_like 等参数化方法

WHERE 条件（AND）— 字符串拼接，存在 SQL 注入风险

⚠️ 已废弃：请使用 where_eq / where_gt 等参数化方法替代。

pub fn or_where(self, condition: impl Into<String>) -> Db

👎Deprecated since 1.3.0:

P0-2: 字符串拼接存在 SQL 注入风险，请使用 or_where_eq/or_where_ne/or_where_gt 等参数化方法

WHERE 条件（OR）— 字符串拼接，存在 SQL 注入风险

⚠️ 已废弃：请使用 or_where_eq / or_where_gt 等参数化方法替代。

pub fn where_eq(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化等值条件 field = ?（AND 关系）

pub fn where_ne(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化不等条件 field != ?（AND 关系）

pub fn where_gt(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化大于条件 field > ?（AND 关系）

pub fn where_ge(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化大于等于条件 field >= ?（AND 关系）

pub fn where_lt(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化小于条件 field < ?（AND 关系）

pub fn where_le(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化小于等于条件 field <= ?（AND 关系）

pub fn where_like(self, field: impl Into<String>, pattern: Value) -> Db

P0-2：参数化 LIKE 条件 field LIKE ?（AND 关系）

pub fn or_where_eq(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化 OR 等值条件 OR field = ?

pub fn or_where_ne(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化 OR 不等条件 OR field != ?

pub fn or_where_gt(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化 OR 大于条件 OR field > ?

pub fn or_where_ge(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化 OR 大于等于条件 OR field >= ?

pub fn or_where_lt(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化 OR 小于条件 OR field < ?

pub fn or_where_le(self, field: impl Into<String>, value: Value) -> Db

P0-2：参数化 OR 小于等于条件 OR field <= ?

pub fn or_where_like(self, field: impl Into<String>, pattern: Value) -> Db

P0-2：参数化 OR LIKE 条件 OR field LIKE ?

pub fn where_in(self, field: impl Into<String>, values: Vec<Value>) -> Db

WHERE IN

pub fn where_not_in(self, field: impl Into<String>, values: Vec<Value>) -> Db

WHERE NOT IN

pub fn where_between( self, field: impl Into<String>, start: Value, end: Value, ) -> Db

WHERE BETWEEN

pub fn where_null(self, field: impl Into<String>) -> Db

WHERE IS NULL

pub fn where_not_null(self, field: impl Into<String>) -> Db

WHERE IS NOT NULL

pub fn order_by(self, field: impl Into<String>) -> Db

ORDER BY field ASC

pub fn order_desc(self, field: impl Into<String>) -> Db

ORDER BY field DESC

pub fn group_by(self, field: impl Into<String>) -> Db

GROUP BY

pub fn having(self, condition: impl Into<String>) -> Db

HAVING

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

LIMIT

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

OFFSET

pub fn page(self, page: usize, page_size: usize) -> Db

分页（page 从 1 开始）

pub fn join_inner( self, table: impl Into<String>, on_left: impl Into<String>, on_right: impl Into<String>, ) -> Db

INNER JOIN

pub fn join_left( self, table: impl Into<String>, on_left: impl Into<String>, on_right: impl Into<String>, ) -> Db

LEFT JOIN

pub fn join_right( self, table: impl Into<String>, on_left: impl Into<String>, on_right: impl Into<String>, ) -> Db

RIGHT JOIN

pub fn build_select(&self) -> String

构建 SELECT SQL

pub fn build_insert(&self, data: &HashMap<String, Value>) -> String

构建 INSERT SQL

pub fn build_update(&self, data: &HashMap<String, Value>) -> String

构建 UPDATE SQL

pub fn build_delete(&self) -> String

构建 DELETE SQL

pub fn build_count(&self) -> String

构建 COUNT SQL

pub fn build_exists(&self) -> String

构建 EXISTS SQL

pub fn build_max(&self, field: &str) -> String

构建 MAX SQL

pub fn build_min(&self, field: &str) -> String

构建 MIN SQL

pub fn build_sum(&self, field: &str) -> String

构建 SUM SQL

pub fn build_avg(&self, field: &str) -> String

构建 AVG SQL