I think it's just part of SQLite's broader design philosophy of having a minimal set of core datatypes and leaning heavily on dynamic typing.

There's a bit more info here: https://www.sqlite.org/datatype3.html