Postgres TEXT columns are recommended by the the core developers, yet Directus limits text functionality vs varchar

[bamboowonder]

Describe the Bug

TEXT and VARCHAR are functionally identical in Postgres, and the devs recommend using TEXT.

https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_varchar.28n.29_by_default

However in Directus, a lot of functionality is limited only to fields recognized as a short string/varchar. text is treated like as a large text field like the mysql paradigm.

If the Postgres database only uses text/citext, instead of varchar, then none of the possible Display/Interface options are available (that string/varchar have).

Additionally there is no way to hint to Directus, or cast a column as another type.

Ideally, it would be possible to override the detected datatype in the schema DataModel screen.

To Reproduce

Create two fields. One varchar, and one text.
Note the difference in Directus for possible Display/Interface options.
The recognized datatype is a read-only field.

Errors Shown

No response

What version of Directus are you using?

9.8.0

What version of Node.js are you using?

16.14.2

What database are you using?

postgres 14

What browser are you using?

chrome

How are you deploying Directus?

CLI npm package