How does `nullable=False` work in SQLAlchemy

The doc you reference explains the issue:

This parameter is only used when issuing CREATE TABLE statements.

If you originally created your database without nullable=False (or created it in some other way, separate from SQLAlchemy, without NOT NULL on that column), then your database column doesn't have that constraint information. This information lives in reference to the database column, not to a particular instance you are creating/inserting.

Changing the SQLAlchemy table creation, without rebuilding your tables, means changes will not be reflected. As a link in a comment explains, SQLAlchemy is not doing the validation at that level (you would need to use the @validates decorator or some other such thing).

When you first created a Location instance and committed it to the database, was nullable set to True? if so, sqlalchemy will NOT allow you to subsequently reset the nullable parameter to False.

You would have to migrate your database using Alembic.