Add dialect descriptions in connector readme

**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.
