Leave connection creation to dialects

[redcatbear]

Situation

At the moment a connection to the remote data source is created regardless of whether we need it or not inside the dialect. This hinders some speedups like caching remote metadata.

Instead of injecting the connection when creating a dialect, we should inject the connection factory, so that the dialect can control whether or not it needs to open a remote connection for a certain task.

For example there is not a single dialect that needs a connection in order to report capabilities.

Acceptance Criteria

1. VS adapter injects connection factory instead of connection into a dialect.