Skip to content

[Feature Request] 添加配置可开启内嵌视图后进行的where尽量内置(只针对简单的别名和and查询) #405

@xingyunxing

Description

@xingyunxing

如easyEntityQuery.queryable(BlogEntity.class)
.leftJoin(Topic.class, (t_blog, t_topic) -> t_blog.id().eq(t_topic.id()))
.select((t_blog, t_topic) -> new TopicAndBlogVOProxy()
.column1().set(t_blog.title()) //列1
.column2().set(t_topic.title()) //列2
)
.where(o -> o.column1().eq("3"))
.toList();
原来生成的是
select column1,column2 from (SELECT
t.title AS column1,
t1.title AS column2
FROM
t_blog t
LEFT JOIN
t_topic t1
ON t.id = t1.id )
where column1 = '3'

如果开启where内置期望生成 select column1,column2 from (SELECT
t.title AS column1,
t1.title AS column2
FROM
t_blog t
LEFT JOIN
t_topic t1
ON t.id = t1.id
where t.title = '3') t

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions