OUTER/RIGHT OUTER JOIN в SQLite

Another argument I have heard against SQLite is that it can be un-predictable when used as a cross network multi-user database, this is probably a fair comment but it is a bit like saying that a free bicycle is slower than a Ferrari and will take you much longer to travel 100 miles. If you are developing a networked multi-user database application then I would suggest you use a database that has actually been designed and built for that purpose like mySQL or Postgres.

Насколько я понимаю, это избыточная реализация. LEFT OUTER есть, и достаточно. Все остальное можно сделать костылями.
https://en.wikipedia.org/wiki/Join_(SQL)#Full_outer_join

пока не сделали, но хотят: http://www.sqlite.org/sessions/omitted.html