Is there a concept of a schema-less JSON SQLite DB? My reason is simple: versioning. We have lot of business metrics that get updated let's say once a month, and we need to be agile to get them. Right now, we just put the version in the SQLite file, and then make sure no queries cross the boundaries.
Secondly, we have requirements for slightly hierarchal data, i.e. mostly row form, but then some guy wants to put an object. What's the SQLite community heading towards if at all? Do others have experiences and requirements similar to this?