It's certainly quite pleasant to work with...but I would rather use sql for etl, the backend be whatever it needs to be...
The real world data transformations can get gnarly very quickly and sql is the perfect common debiminator compared to dplyr which is still niche...
How do you feel about polars?