Struct LinqQuery 

pub struct LinqQuery { /* private fields */ }

LINQ 风格查询构建器

Implementations

impl LinqQuery

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

FROM 子句 — 指定表名

pub fn select(self, cols: Vec<&str>) -> Self

SELECT 子句 — 指定列

pub fn where_eq(self, field: &str, value: Value) -> Self

WHERE 等于条件

pub fn where_ne(self, field: &str, value: Value) -> Self

WHERE 不等于条件

pub fn where_gt(self, field: &str, value: Value) -> Self

WHERE 大于条件

pub fn where_lt(self, field: &str, value: Value) -> Self

WHERE 小于条件

pub fn where_ge(self, field: &str, value: Value) -> Self

WHERE 大于等于条件

pub fn where_le(self, field: &str, value: Value) -> Self

WHERE 小于等于条件

pub fn where_like(self, field: &str, pattern: Value) -> Self

WHERE LIKE 条件

pub fn where_in(self, field: &str, values: Vec<Value>) -> Self

WHERE IN 条件

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

WHERE IS NULL

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

WHERE IS NOT NULL

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

ORDER BY 升序

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

ORDER BY 降序

pub fn take(self, n: usize) -> Self

TAKE — 取前 N 条（等价于 LIMIT）

pub fn skip(self, n: usize) -> Self

SKIP — 跳过 N 条（等价于 OFFSET）

pub fn distinct(self) -> Self

DISTINCT — 去重

pub fn group_by(self, cols: Vec<&str>) -> Self

GROUP BY — 分组

pub fn build(&self) -> String

构建 SQL

pub fn params(&self) -> &[Value]

获取参数

pub fn build_count(&self) -> String

构建 COUNT 查询

pub fn build_exists(&self) -> String

构建 EXISTS 查询