can we have production migrations recommendations docs for drizzle?

Right now, when using migrations, frequent errors occur when data exists for a column and then there is an alter command for that column. Worse is when those migrations happened in a different file, and the other migrations are applied, we cannot rollback, causing the site to not run properly. That's the state where we'll have to manually fix issues.