How (in TypeORM or not only) to search through nested database fields?

Question

SQL

Hardcore (demonstrative) example: you need to find the user User, whose user.address.street.name === '...'
It turns out that here you need to do 2 joins and compare deep fields. How to do it right?
Ideally, the question is about the high-level features built into the TypeORM (Node.js) library.
Connoisseurs of SQL, please recall the native query to the database.

Answer 1

perhaps the most relevant to your request in the typeorm documentation will be here https://github.com/typeorm/typeorm/blob/master/doc...
emphasis aside

userRepository.find({ relations: ["profile", "photos", "videos", "videos.video_attributes"] });