For something used in so many places for so many reasons it's interesting to read everything they test for their releases...
https://www.sqlite.org/testing.html
> Fix an incorrect result from a query that uses a view that contains a compound SELECT in which only one arm contains a RIGHT JOIN and where the view is not the first FROM clause term of the query that contains the view