The main problem with that is awk breaks down as soon as you have comma in your csv's data. There is frawk if you want to process csv with awk.
Instead of using awk/gawk straight up/out of the box, can code/program awk/gawk or use non-awk/gawk stuff to convert to different format to work around issue.
[edit this when have simple working example:
edit1: one non-awk/gawk way to avoid the cvs comma issue would be to use jq to convert column data to different format.
]