Verbose toggle for cli migrate (and other commands)

[nervetattoo]

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.

[hfoffani]

I'm seeing this error too from edgedb watch in a specific db change.

Schema migration error: ClientConnectionEosError: connection closed by server
[2024-03-01T15:31:27Z ERROR edgedb::watch::main] Cannot set database error state: ClientInconsistentError

(server is in version 3.x)