> SQLite also always had a null type, surely?

In 'stringly typed' languages, the natural value of NULL is the empty string.

SQLite currently distinguishes between "" and NULL, and I don't know if this was always the case. But it's quite possible that SQLite 1 and 2 conflated the empty string and NULL.