Is NULL in FooColumn2 TEXT NULL an explicit way to say nullable? Or does it mean something different?
CREATE TABLE IF NOT EXISTS FooTable (FooColumn1 TEXT NOT NULL, FooColumn2 TEXT NULL)
>Solution :
Normally, by default it’s nullable if not explicitly stated as NOT NULL; does not look like NULL is part of the column constraint at all:

source: https://www.sqlite.org/lang_createtable.html