I want to create a database that will be for local use on iOS/iPadOS devices initially, but could potentially be used for cloud backup and sync across devices later. Is sqlite and CloudKit a good choice for this, or do I need another option?
Best options for database, cloud backup and sync
CoreData. The answer is always CoreData. And if you're planning for sync, just enable CoreData-CloudKit from the start, because migrations after-the-fact won't be easy.