jet icon indicating copy to clipboard operation
jet copied to clipboard

Subquery with select function

Open abasile15 opened this issue 7 months ago • 1 comments
trafficstars

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

abasile15 avatar Mar 25 '25 15:03 abasile15