Support implicit join
Open
enhancement
- Dominant language
- Kotlin
- Stars
- 9.3k
- Forks
- 798
- Avg merge
- 4d 2h
- Merged PRs (30d)
- 26
Description
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
```
Contributor guide
Assessment
This issue has not been assessed yet.