Earlier quoted context omitted.
Are you telling me that awk can correctly identify delimiters inside quoted strings? Escaped quotes inside quoted strings? Newlines inside quoted strings? I.e. that awk actually has a csv parser? Very cool if so.
Yeah, you can implement a basic FSM and use `next` to handle fake `RS` (e.g. newlines). I'm not necessarily recommending it, but it's certainly possible and could be portable and really fast to run with a low memory footprint.
Personally I prefer using a readymade and tested library in any language that I might touch, so I can just do my own thing on top. Or, in command line, to use an util that employs such a library. Kind of hope that I'm never so constrained that only awk is available and I can't even spin up Lua.