Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support implicit join #443

Open
raderio opened this issue Dec 8, 2018 · 1 comment
Open

Support implicit join #443

raderio opened this issue Dec 8, 2018 · 1 comment

Comments

@raderio
Copy link

raderio commented Dec 8, 2018

Can you please add support for implicit join?

An example can be find here https://blog.jooq.org/2018/02/20/type-safe-implicit-join-through-path-navigation-in-jooq-3-11/

Idea is instead of

SELECT  
  cu.first_name,  
  cu.last_name,  
  co.country
FROM customer AS cu
JOIN address USING (address_id)
JOIN city USING (city_id)
JOIN country AS co USING (country_id)

we can write

SELECT
  cu.first_name,
  cu.last_name,
  cu.address.city.country.country
FROM customer AS cu
@unodgs
Copy link

unodgs commented Aug 20, 2019

I'm against it. It makes hard to understand what really is going on underneath. Query looks like simple select but it isn't like that at all. I prefer being a little bit more explicit but more understandable at the same time.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants