Few questions:
1. Core Data {is|can be} backend by SQLite, so why can't you use CoreData ? I mean, you can programatically attach new backing stores to CoreData, AFAIK on-the-fly, there's even a talk on WWDC 2011 about such hacks.
2. Since iOS 5.0 you can provide your own solutions in terms of incremental backing stores
3. RestKit can map to CoreData using RKManagedObjectMappings or to simple NSObject subclasses via RKObjectMapping. Then you can grab your objects in proper delegate callback, map/deserialize and save to SQLite
In my private opinion using raw SQLite in iOS is generally bad idea. It's slower than CoreData (CoreData is up to 70% faster, if properly handled), requires you to write a lot of boilerplate code and has rather unusable API. Also, CoreData integrates extremelly well into CocoaTouch, especially UITableViewController
--
---------------------------
Michał Domański