resolveDialect method
What the server is, asked once per capabilities cache.
The same resolution the generated table queries use, so a builder query run through query cannot compile 2012 paging against a database whose compatibility level refuses it.
Implementation
Future<MssqlDialect> resolveDialect() => capabilities.resolve(session);