How to fetch multiple relations in one request? Is it possible?

[ziimakc]

I would like to fetch multiple relations in one request to save db round-trips, similar to prisma:

join (default): Uses a database-level LATERAL JOIN (PostgreSQL) or correlated subqueries (MySQL) and fetches all data with a single query to the database.

Is it possible in sea-orm?

[Expurple]

Yes, there are methods like find_{also,with}_{linked,related} and select_also. At the moment, those allow you to select up to 3 models (tables).

If you need more, at the moment you have to avoid these high-level "relational" methods and manunally write joins, manually select every column, manually define a result struct, #[derive(FromQueryResult)] on it, and use .into_model::<YourResultStruct>() to collect the result of the query into that struct.

This is one of the biggest known issues with SeaORM, and there are many discussions (and some draft PRs) about it.