Skip to content

Subquery with select function #474

Open
@abasile15

Description

@abasile15

Is your feature request related to a problem? Please describe.
When go-jet generates a subquery that returning a function like max(updateTime), the inner join condition assumes it's named as table.column.
After sometime, I found a simple solution where the alias has the table in the name.
i.e. SELECT(
MAX(table.MyTable.UpdateTime).AS("my_table".update_time"),

Describe the solution you'd like
Each 1st time user could save time if go-jet would take functions into account when generating the link conditions. This way we won't have to use an alias, and better yet prepend an unintuitive table name

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions