Querying JSONB type in Postgres

There are a number of native PostgreSQL data types that seem not to be supported, including JSONB. Is there an easy way to add JSONB support, even if it’s just cast to TEXT?

PostgreSQL supports a wide variety of data types, the easiest method today is to create a view in PG that casts columns of interest to a string type and have Dremio read from the view. This uses PG’s own casting logic and can be used to read the larger number of data types PG supports.