Hi,
1. So far, we don't support SQLLite, we have not had a lot of requests or use cases for it.
2. No, we don't support this type of application
3. Yes, and the album as well
4. The framework generates 100% open source code, there is no dependency on Canappi once you take that code and extend it with your own custom code.
Canappi is not trying to remove all possible custom code, you can think of Canappi as a tool like Interface Builder that allows you to create parts of the application easily, but does not remove the need to code for features that are not covered by the tool.
Canappi has a much deeper programming model when compared to Interface Builder, here is a post on the 10 things Canappi can do that IB cannot do:
http://www.canappi.com/pages/blog-article?r=WZ2W6BKLJAit also allows you to use Interface Builder to design Android Layouts for instance.
Let us know if you have other questions. We are about to release Canappi 1.3 (within one week), with integrated support for Amazon S3 for instance, and many other new features.
JJ-