There’s always nushell. It’s fairly new, not quite to 1.0 yet (0.96.1 at time of writing), but the constant breaking changes seemed to have stopped. It hits all your points and it’s quite fun to use when writing scripts. Bonus that it’s also pretty much tailor-made to manipulate data.