java/kotlin high performance lightweight solution for jdbc query,support oltp and olap query,一款java下面支持强类型、轻量级、高性能的ORM,致力于解决jdbc查询,拥有对象模型筛选、隐式子查询、隐式join
SELECT COUNT(*)
FROM `sys_role` t
WHERE t.`del_flag` = ? AND t.`role_id` = t1.`role_id`
AND EXISTS (SELECT 1 FROM `sys_role` t1
LEFT JOIN `sys_user_role` t2 ON t1.`role_id` = t2.`role_id`
LEFT JOIN `sys_user` user ON t2.`user_id` = user.`user_id`
LEFT JOIN `sys_dept` dept ON user.`dept_id` = dept.`dept_id`
WHERE ( dept.dept_id IN ( SELECT dept_id FROM sys_role_dept
WHERE role_id = 2 ))
);
如果 使用
主表.主表字段 = 子表.子表字段
生成的拼接条件有问题,示例语句其中 表连接条件
t.
role_id= t1.
role_id` 跑到
exists` 外面了