Since SQLite doesn't support the ALTER TABLE command, running migrations that alter the structure of database tables with alembic fails. To fix this, alembic provides a render_as_batch option, which will instead create new tables, copy the data over from the old ones and then remove the old ones, bypassing this limitation.
Since SQLite doesn't support the
ALTER TABLE
command, running migrations that alter the structure of database tables with alembic fails. To fix this, alembic provides a render_as_batch option, which will instead create new tables, copy the data over from the old ones and then remove the old ones, bypassing this limitation.