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.
Albert Drent
