These type of libraries are cool for small and non-complicated things. None of them can compete with the expressiveness of SQL, as it is based in relational algebra.
Leaving some technicalities aside, SQLite is SQL. So I guess we're not talking the same here.