I’m working on my app to replace my SQLite database with Couchbase Lite, which will bring a much needed feature such as real-time synchronization.
However, I’m wondering what kind of queries I’ll be able to do on Couchbase Lite. Will I be able to run “complex” N1QL queries using features like UNNEST, JOIN and aggregation operators (AVG, SUM, COUNT, etc.)?
Also, is there a way to run raw N1QL queries?