Not any more. SQLite received support for RIGHT and FULL OUTER joins in 3.39.0, released over a year ago.