Unconsumed column name when column actually exists and is correct case

def update_sqalchemy_zone_config(table_name, zone_name, field_name, field_value):
    metadata = MetaData(bind=None)
    table = Table(table_name, metadata, autoload=True, autoload_with=engine)
    stmt = table.update().where(table.c.name == zone_name).values(field_name = field_value)  

update_sqlachemy_zone_config('zones', 'zone1', 'enabled', False)

results in:

sqlalchemy.exc.CompileError: Unconsumed column names: field_name

However, if I change field_name to enabled (my field name) it works: from: stmt = table.update().where(table.c.name == zone_name).values(field_name = field_value) to: stmt = table.update().where(table.c.name == zone_name).values(enabled = field_value)

MYSQL 8.0.19 Linux Ubuntu 18.04.3 LTS

There is only one table in my database and it is called zones and only one column in that table is called enabled.

print(table.c.keys()) ['name', 'zone_number', 'description', 'gpio', 'enabled']

from sqlalchemy.schema import CreateTable print(CreateTable(table).compile(engine)

CREATE TABLE zones (
    name VARCHAR(15) COLLATE utf8_unicode_ci NOT NULL, 
    zone_number TINYINT NOT NULL, 
    description VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL, 
    gpio TINYINT(1) NOT NULL, 
    enabled TINYINT(1) NOT NULL, 
    PRIMARY KEY (zone_number)
)DEFAULT CHARSET=utf8 ENGINE=InnoDB COLLATE utf8_unicode_ci