It is. They even consider it a feature.

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.