TSV to CSV on the CLI (if you really have to)

Regular visitors to this blog will know that I don’t like the CSV format. It’s awful. In my humble opinion, data workers should aim to use invisible tabs (TSV) or visible pipes (PSV) as field separators in delimited text tables. Sometimes, though, data workers are required to convert a perfectly good TSV or PSV to a CSV. What to do?