add ability to determine dialect migration support

This provides the ability to determine whether a given dialect
is supported for migrations. This is mostly another switch that
allows incremental implementation of new dialects.