Query: security_headers_x_frame_options_check

select
  case
    when response_headers -> 'X-Frame-Options' is not null then 'Present'
    else 'Missing'
  end as value,
  case
    when response_headers -> 'X-Frame-Options' is not null then 'ok'
    else 'alert'
  end as type,
  'X-Frame-Options' as label
from
  net_http_request
where
  url = $1;