Flask DB migrate to drop column with sqlite

gistfile1.txt

Example to drop a column title in a posts table:

# Generate by Alembic
def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_posts_title'), table_name='posts')
    op.drop_column('posts', 'title')
    
$ flask db downgrade
....
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "DROP": syntax error

# Modify the downgrade by `batch_op`:
# creating a new table with a column removed, 
# dropping the old table
# renaming the new table with the old table's name
def downgrade():
    with op.batch_alter_table("posts") as batch_op:
        # batch_op.drop_index(op.f('ix_posts_title'))
        # Remove the table name
        batch_op.drop_column('title')