> Reading the 'unsupported features page' there's a feature > request about allowing the + and - join syntax like oracle > has. It would allow more easy readable and writable queries > although I know it's not quite standard. SQLite used to have > this (I read) but has been removed.
I think I'd not find such a feature useful. Adding non-SQL standard functionality to SQLite is a good idea when it provides some clearly needed functionality, or when it supports the design goals of the product. However, simply adding support for a different *notation* for already existing functionality, i.e. joins, would seem, IMNECTHO, to be not worth the effort. For one thing, it adds code without adding any new real functionality. That increases the size of SQLite, thus going *against* one of the product's goals.