Also is prisma considering supporting custom migrations? For example if I want to run some sql to change all emails in the db to lowercase?

Yes that’s something that we will be taking into consideration. @Alberto Perdomo can possibly elaborate more on this.