You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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.
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
we can write
The text was updated successfully, but these errors were encountered: