I'm using the DAO API, and I want to find objects based on something they reference, for example:

User.find { Users.city.name eq "London" }

This doesn't work, because I cannot access properties of the

city

reference this way, what's the correct way? This could be normally solved with a join, but I can't find anything on joins with the DAO API. I'm struggling to find a way that doesn't involve loading all the users from the database just to filter them in application code.

I just update wiki to cover that case https://github.com/JetBrains/Exposed/wiki/DAO#read-entity-with-a-join-to-another-table

That's great. Thank you!