Views sometimes come with drawbacks, so are Domain Representations supported?

[thadguidry]

See: Domain Representations

Domain Representations separates “how the data is presented” from “how the data is stored”. It works by creating domains and casts, the latter act on the former to present and receive the data in different formats.

Views come with drawbacks that do increase complexity.
For details see Advantages over Views

Domain Representations avoid all the above drawbacks. Their only drawback is that for existing tables, you have to change the column types. But this should be a fast operation since domains are binary coercible with their underlying types. A table rewrite won’t be required.

[kdhrubo]

I believe this can be supported in both a database native way as well as a database-independent way.

For example, DB2Rest has plans for such representation in the roadmap.
https://sqids.org/