SQLite imports from CSV as text data by default

This means that you won’t have NULL values where you should. You can fix this with an update statement like

UPDATE some_import_table
SET
  "value" = NULL
WHERE
  "value" = '';