https://www.youtube.com/watch?v=hJhZhLg3obk "Amjith Ramanujam Awesome Command Line Tools PyCon 2017" goes through some nice examples: mycli, pgcli, fish shell and few others
It works fairly nice with ConEmu and other terminals. The performance is also quite good: I installed clang and built a big-ish C++ project and it compiled faster than using MSVC on Windows directly (10 vs 12 mins, roughly).
I couldn't get zsh to work (same errors as tallanvor) but other shells did work, like fish with oh-my-fish. I had to run bash in ConEmu to be able to display some unicode characters (those used by powerline themes/fonts) - http://i.imgur.com/JT8Zi5j.png