sqlalchemy-bot

**Changes by Michael Bayer ([@zzzeek](https://github.com/zzzeek)):** * added labels: **postgresql typing issues**

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** hi there - This is likely not a common use case, since for manual migrations people just log into their database and type ALTER commands. If...

**Glen Fletcher wrote:** Yes Thank you for the help, that covers what I need but I think you misunderstood what I meant by manual, I want to write a system...

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** you're looking for the API. It's documented, extensively, start at https://alembic.zzzcomputing.com/en/latest/api/index.html. the above session is already described in the "Operation Directives" section.

**Changes by Glen Fletcher:** * edited description

**Changes by Michael Bayer ([@zzzeek](https://github.com/zzzeek)):** * removed labels: **bug** * added labels: **feature**

**Changes by Michael Bayer ([@zzzeek](https://github.com/zzzeek)):** * added labels: **documentation**

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** well we don't have CREATE VIEW. That's been only a recipe: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/Views implementing that fully is a much bigger issue. seems more appropriate to have drop_view...

**David Layton ([@dmlayton](https://github.com/dmlayton)) wrote:** I am using the stated recipe which works great, but alembic is not making migrations for the views. I am new to alembic. I see the...

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** note this is a documented limitation: http://alembic.zzzcomputing.com/en/latest/autogenerate.html#what-does-autogenerate-detect-and-what-does-it-not-detect