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