text: create or replace view dfs.subqueries.optional_type_v as
  select
          cast(c_varchar as varchar(100))		as c_varchar,
          cast(c_integer as integer)		as c_integer,
          cast(c_bigint as bigint)		as c_bigint,
          cast(c_float as float)			as c_float,
          cast(c_double as double)		as c_double,
          cast(c_date as date)			as c_date,
          cast(c_time as time)			as c_time,
          cast(c_timestamp as timestamp)		as c_timestamp,
          cast(c_boolean as boolean)		as c_boolean
  from
      dfs.subqueries.j1
  ;
  
  create or replace view dfs.subqueries.required_type_v as
  select
          cast(c_varchar as varchar(100))		as c_varchar,
          cast(c_integer as integer)		as c_integer,
          cast(c_bigint as bigint)		as c_bigint,
          cast(c_float as float)			as c_float,
          cast(c_double as double)		as c_double,
          cast(c_date as date)			as c_date,
          cast(c_time as time)			as c_time,
          cast(c_timestamp as timestamp)		as c_timestamp,
          cast(c_boolean as boolean)		as c_boolean
  from
      dfs.subqueries.j3
  ;
  