How do you migrate in place data that doesn’t convert between types while maintaining a strict condition like NOT NULL?

This is again a scenario I’ve never run into 20ish years of SQL.

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

	▲	grebc 5 hours ago \| parent [-]
		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.