SQL SQL Supporting Status Totally Supported Regular Query Subquery Sharding value in expression Experimental Supported Subquery Join with cross databases Unsupported SQL Ex...

检索单个对象 根据主键检索 检索全部对象 条件 String 条件 Struct & Map 条件 Specify Struct search fields Inline Condition Not Conditions Or Conditions 选择特定字段 Order Limit & Offset Group & Having...

断言 字段断言 Edge 断言 否定 (NOT) 析取 (OR) 合取 (AND) 自定义断言 Get all pets of users 1, 2 and 3 Count the number of users whose JSON field named URL contains the Scheme key Get all users...

Predicates Field Predicates Edge Predicates Negation (NOT) Disjunction (OR) Conjunction (AND) Custom Predicates Get all pets of users 1, 2 and 3 Count the number of users who...

检索单个对象 检索对象 条件 String 条件 Struct & Map 条件 内联条件">内联条件 Not 条件 Or 条件 选择特定字段 Order Limit & Offset Group & Having Distinct Joins Joins 预加载 Scan">Scan 检索单个对象 GORM 提供 ...

Delete a Record Delete with primary key Delete Hooks Batch Delete Block Global Delete Returning Data From Deleted Rows Soft Delete Find soft deleted records Delete permanent...

Retrieving a single object Retrieving objects with primary key Retrieving all objects Conditions String Conditions Struct & Map Conditions Specify Struct search fields Inline...

断言 字段断言 Edge 断言 否定 (NOT) 析取 (OR) 合取 (AND) 自定义断言 Get all pets of users 1, 2 and 3 Count the number of users whose JSON field named URL contains the Scheme key Get all users...

断言 字段断言 Edge 断言 否定 (NOT) 析取 (OR) 合取 (AND) 自定义断言 Get all pets of users 1, 2 and 3 Count the number of users whose JSON field named URL contains the Scheme key Get all users...

SQL SQL 支持程度 稳定支持 常规查询 子查询 运算表达式中包含分片键 实验性支持 子查询 跨库关联查询 不支持 SQL 示例 SQL SQL 支持程度 稳定支持 实验性支持 不支持 SQL 示例 SQL 支持程度 兼容全部常用的路由至单数据节点 的 SQL； 路由至多数据节点 的 SQL 由于场景复杂，分...