Hi,
After doing some tests, I noticed that Denodo reads JSON and JSONB format as text.
Denodo provides the function [JSONPATH](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/json_functions/json_functions#jsonpath) to navigate JSON strings, you can use it to extract the fields you need creating new columns in a Selection View or similar.
For instance:
```
select JSONPATH(
'{
"field_a": 1,
"field_b": 2,
"field_c": 3
}', '$.field_a')
from dual();
```
As a second solution, but I think it has much more complexity, you could:
* Define a custom type based on your JSON structure.
* Create a base view with your custom type.
* Define a custom wrapper to be associated with your Base View.
* Alter the search method of your Base View in order use the custom wrapper.
You can find an example here: [Processing of Compound Types: Example](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/advanced_characteristics/management_of_compound_values/processing_of_compound_types_example).
Hope this helps
