Data type compatibility

SELECT
  id,
  smallint_col::INTEGER AS int_val,
  int_col::BIGINT AS big_val,
  numeric_col::NUMERIC(18,4) AS precise_val,
  real_col::DOUBLE PRECISION AS float_val,
  money_col::TEXT AS money_text
FROM {{ source }}

SELECT
  id,
  created_at::DATE AS date_only,
  event_ts::TIMESTAMPTZ AS event_utc,
  EXTRACT(EPOCH FROM event_ts) AS epoch_seconds,
  interval_col::TEXT AS duration_text
FROM {{ source }}

SELECT id, encode(bytea_col, 'hex')::TEXT AS bytea_hex FROM {{ source }}

SELECT
  id,
  inet_col::TEXT AS ip_address,
  cidr_col::TEXT AS network,
  macaddr_col::TEXT AS mac
FROM {{ source }}

SELECT
  id,
  jsonb_col->>'name' AS name,
  (jsonb_col->>'price')::NUMERIC AS price,
  jsonb_col->'tags' AS tags_jsonb
FROM {{ source }}

SELECT
  id,
  int_array_col::TEXT AS int_array_text,
  text_array_col::TEXT AS text_array_text
FROM {{ source }}

SELECT
  id,
  int4range_col::TEXT AS int_range,
  int8range_col::TEXT AS bigint_range,
  numrange_col::TEXT AS num_range,
  tsrange_col::TEXT AS ts_range,
  tstzrange_col::TEXT AS tstz_range,
  daterange_col::TEXT AS date_range
FROM {{ source }}

SELECT
  id,
  tsvector_col::TEXT AS document_vector,
  tsquery_col::TEXT AS search_query
FROM {{ source }}

SELECT
  id,
  person_col::TEXT AS person_text,
  item_col::TEXT AS item_text
FROM {{ source }}

SELECT
  id,
  mood_col::TEXT AS mood,
  status_col::TEXT AS status
FROM {{ source }}

SELECT
  id,
  smallint_col::BIGINT AS widened_to_bigint,
  int_col::NUMERIC AS widened_to_numeric,
  char_col::TEXT AS widened_to_text,
  varchar_col::TEXT AS widened_to_text,
  real_col::DOUBLE PRECISION AS widened_to_float8,
  date_col::TIMESTAMPTZ AS widened_to_tstz,
  timestamp_col::TIMESTAMPTZ AS promoted_to_tstz,
  bool_col::TEXT AS bool_as_text,
  inet_col::TEXT AS inet_text,
  json_col::JSONB AS promoted_to_jsonb
FROM {{ source }}