This.
"limited type system" is actually an exaggeration in my opinion. The "data types" seem to only serve documentation purposes. You can always store any value in any column regardless of the "data type"
You don't actually need to specify column types at all. You can just leave them out. Or make up entirely new types like `BLIB` or whatever.
Foreign key constraints are also not enforced by default but there is at least an option to turn that on.
I'm keeping a close eye on DuckDB which looks like a modern saner version of SQLite.
Yes
https://dbfiddle.uk/?rdbms=sqlite_3.27&fiddle=4634e3821676ed...
You don't actually need to specify column types at all. You can just leave them out. Or make up entirely new types.
Foreign key constraints are also not enforced by default but there is at least an option to turn that on.