Add dialect descriptions in connector readme

[mdazam1942]

Is your feature request related to a problem? Please describe.
Some connectors uses dialect features but we don't have any specific documentation on the dialects that the individual connector uses.

Describe the solution you'd like
Add a section in the connector readme documentation which describes the dialects used by the connector and their usage.