We are using only AWS lambda functions to build the entire project. I planned to use sqlalchemy using AWS lambda layers. To do that I followed the example from AWS github repo. Now I'm having trouble to manage the databse using the sqlalchemy. I want to make changes to a column in a table. Offical way is to use alembic to make the changes. But I can't use the temrinal to do the revision. I want the revision to happen while I'm building the lambda layer. Is that possible? can anyone suggest me a proper setup?
I created the lambda layer to store the sqlalachmey models and I'm able to use it in my current lambdas. But the challenge I'm facing now is, how to handle the column changes, like alter column and creating new tables. In my current setup make columns are non nullable and I want to make them nullable using the orm. How can i achieve it using alembic or any other better ways?