ENH: read_csv dialect parameter can take a string (GH8703)

Closes #8703

I wasn't sure where to put the test, hopefully this is right.

Follow-up of #8718