My use case is following.

$ wp @stag db export --stdout | wp @prod db import -

It looks very useful.
I want to try it.