Speaking of a SQLish DSL for data transformation, I'd recommend checking out PRQL (https://prql-lang.org), which is an interesting Rust-based project in this space.