[FEATURE]: Better migration information

### Describe what you want

I have been testing drizzle and seems like a nice new alternative. Thanks.

I think the migration tool is a bit dry, and it would be better to have an option to show what is happening, for instance which migrations are being applied, how many of them were applied, if it was successful or not, etc. I'm sorry if an issue like this already exists, i could not find them.