You create a nullable column and then change it to not null. Which wasn't possible in SQLite until recently.

I’m not sure what your original point is pointing out.

Some data doesn’t convert is what I’m pointing out regardless of Postgres or SQLite.