Setting the default visualisation format to JSON for PostgreSQL jsonb columns

[Pinimo]

When a column inside a PostgreSQL database is of type jsonb, it would be fantastic to automatically display it as a collapsible JSON in Redash. Currently, our users need to apply this setting manually each time they create a new query, which is a bit tedious.

I saw it is possible to tweak the default float and date visualisations at the organization level, but the same does not seem to be implemented for jsonb-typed columns.

More generally, maybe it would be interesting to offer Redash administrators to customize the default visualisation of any SQL type.