Motivation

I have a foreign key that looks like:

.col(ColumnDef::new(Session::UserId).big_integer().not_null())
...
ForeignKeyCreateStatement::new()
    .from(Session::Table, Session::UserId)
    .to(User::Table, User::Id)

The SQL constraints should mean that every session is associated with a user.

I would like to select sessions with their associated user, so that I get (Session, User), but when I use find_also_related() it returns (Session, Option<User>).

Then I looked at the code behind find_also_related and can see it is using a left join:

self.left_join(r).select_also(r)

What I was really looking to do is an inner join:

self.inner_join(r).select_also(r)

But the problem is that the select_also still returns an Option even after doing an inner_join, surely the User can never be None?

It would be great if there could be an API to make this a bit friendlier?

Additional Information

See also:

• Trying to design simpler inner join #464
• Select one-to-one mandatory relationship #807