add dialect checks for upsert support

Upserts in MSSQL are non-trivial to implement, adding the ability
to test for support is a valid stopgap for later implementation
Merge pull request #2678 from mbroadst/supports-upserts

add dialect checks for upsert support