Support right join by transforming it to left join

[roji]

EF doesn't currently support translating to RIGHT JOIN in any way. With LeftJoin and RightJoin being introduced into .NET 10 (#35379), we should consider adding support for it.

Since adding full support across the query pipeilne may be expensive (that would be #35367), we could consider simply normalizing RightJoin to LeftJoin (flipping around the arguments) - this should be easily doable in preprocessing. Later, based on user feedback, we may do the proper implementation so that the SQL corresponds to the LINQ query.

[roji]

Closing in favor of the proper, full implementation of RIGHT JOIN (#35367).