hx-base/my-test/src/test/java/MySpringBootTest.java

import com.alibaba.fastjson.JSONObject;
import org.dromara.system.domain.SysDept;
import org.dromara.system.service.ISysUserService;
import org.example.DromaraApplication;
import org.example.join.domain.QueryColumn;
import org.example.join.domain.Table;
import org.example.join.sql.Sql;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

import static org.example.join.domain.QueryMethods.concat;

@RunWith(SpringRunner.class)
@SpringBootTest(classes = DromaraApplication.class)
public class MySpringBootTest {

    public static final Table sys_dept = new Table("sys_dept");
    public final QueryColumn dept_id = new QueryColumn(sys_dept, "dept_id");
    public final QueryColumn tenant_id = new QueryColumn(sys_dept, "tenant_id");
    public final QueryColumn parent_id = new QueryColumn(sys_dept, "parent_id");
    public final QueryColumn ancestors = new QueryColumn(sys_dept, "ancestors");

    public static final Table sys_user = new Table("sys_user");
    public final QueryColumn user_id = new QueryColumn(sys_user, "user_id");
    public final QueryColumn user_name = new QueryColumn(sys_user, "user_name");
    public final QueryColumn nick_name = new QueryColumn(sys_user, "nick_name");
    public final QueryColumn sex = new QueryColumn(sys_user, "sex");
    public final QueryColumn create_by = new QueryColumn(sys_user, "create_by");

    @Autowired
    private ISysUserService service;

    @Test
    public void testCache() {

        List<SysDept> list = Sql.create(SysDept.class)
                //.logicIgnore()
                .select(
                        //dept_id,
                        //abs(parent_id).as(SysDept::getUpdateTime),
                        //replace(dept_id, "2", "3"),
                        //concat("@", "1"),
                        concat(dept_id, 1, "',(select config_value from sys_config where config_id = 1749335361951907842),'").as(SysDept::getEmail)
                        //concat(dept_id, parent_id),
                        //concat(dept_id,"sdasdsa"),
                        //dateFormat(now(), "%Y%m"),
                        //ifNull("2", "2")
                )
                .from(sys_dept)
                .leftJoin(sys_user).on(user_id.eq(dept_id))
                .where(
                        //dept_id.add(parent_id).eq(parent_id)
                        //create_by.eq(concat("dept_id", "@", "',(select config_value from sys_config where config_id = 1749335361951907842),'").as(SysDept::getEmail))
                        //create_by.ne(98),
                        //create_by.gt(98),
                        //create_by.lt(98),
                        //create_by.ge(98),
                        //create_by.le(98),
                        //create_by.between(1, 2),
                        //create_by.notBetween(1, 2),
                        //create_by.like(1),
                        //create_by.notLike(1),
                        //create_by.likeLeft(1),
                        //create_by.notLikeLeft(1),
                        //create_by.likeRight(1),
                        //create_by.notLikeRight(1),
                        //create_by.isNull(),
                        //create_by.isNotNull(),
                        //create_by.in(1, 2, 3, 4),
                        //create_by.notIn(1, 2, 3, 4)
                )
                .list();

        System.out.println(JSONObject.toJSONString(list));

    }

}