As SQLite doesn't support [full join and right join](https://www.sqlite.org/omitted.html) the translation for these joins has to be altered for SQLite. Wikipedia shows an example for the [full join](https://en.wikipedia.org/wiki/Join_%28SQL%29#Full_outer_join).
As SQLite doesn't support full join and right join the translation for these joins has to be altered for SQLite.
Wikipedia shows an example for the full join.