They could have tilted the example even more in their favor by using csvs that had a delimiter inside the string (“Smith, John”). Or quoted new lines. That’s an “edge case” where I know I cannot lean on cli tooling and need to use a real language.
I think they were trying to keep the examples simple but you’re right. Parsing CSV is a mess — DuckDB does a decent job at it with its CSV sniffer but most CSV tooling have a ton of switches for corner cases.