Even if you do not want to create a flatten view, you can still use the FLATTEN operation to flatten an array. I used the following syntax to get the field values of an array.
SELECT <column_name> FROM FLATTEN <view_name> AS <alias> (<alias>.<column_name>)
The FLATTEN operation returns the fields of the source view— except the flattened array— and all the fields of the registers of the array field being flattened.
For more information on this, you can refer to [FLATTEN View (Flattening Data Structures)](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/queries_select_statement/from_clause/flatten_view_flattening_data_structures) in the Virtual DataPort VQL Guide.
Hope this helps!