I think the main thing Awk is missing is standard support for CSV (with quoting). The recent goawk has it, though.
https://github.com/ezrosent/frawk also supports csv
And handling it with awk: https://stackoverflow.com/questions/45420535/whats-the-most-...