Yes, but with sqlite there is much less ceremony (no server, etc.) and most importantly can be used without talking to my institution's sysadmin, which is what I'm looking for when manipulating one-off datasets.

But that advantage has nothing to do with accepting data of the wrong type into a column (by default).