refactor index validation and prevent indexes over json columns

[jycor]

This PR consolidates the logic to validate if an index. Additionally, it fixes a bug where create table t (i int, index (i, i)); was allowed.

fixes: https://github.com/dolthub/dolt/issues/6064