Verbose toggle for cli migrate (and other commands)

When a migration apply fails it can lead to this error message, with no knowledge of what failed:
```
edgedb error: ClientConnectionEosError: end of stream while reading message
edgedb error: error in one of the migrations
```
The error message should ideally include a full stack trace, at least show me:
1. The failing query
2. The migration id

I also note that the CLI in general is sans verbose mode. I kind of want the same for `dump` and `restore`. When dumping/restoring a big db it would be great to get some feedback while I wait 15-20 minutes for it to complete. A progress bar would be great as the default but just give me a `-v` flag to print something for every statement that runs.