Allow specifying more facets on JSON column

[AndriySvyryd]

In addition to #28452 and #28584 we should allow specifying Comment, DefaultValue and other applicable facets
Consider using a separate builder, like the one used in ToTable

[ajcvickers]

Note: consider "sparse" and other provider-specific facets.

[KLuuKer]

MaxLength please i only need like 50 char's max not 2gigabytes