Caveat: indexes don't currently work, I'm writing that code as we speak. SQLite supports any type of data in colums, regardless of what the column type actually is, which is what allows you to just define your fields to be indexed and have it work.

I think this project is a good fit for small, exploratory/prototyping projects that need powerful querying capabilities but don't know what the final schema will look like yet.

That's what I'm using it for, anyway.