In doing all of the above, SQLite should actually be simpler to implement, and it will be easier to use, with more predictable results and fewer bugs.
Only for some applications. It would be harder to use for my apps. Specifically manifest typing as currently implemented in SQLite is a perfect match for apps writen in Python (which also uses manifest typing). It would require a lot more code to go through and force the data type for each column.
Roger