SQL output of ActiveRelation or Arel query that I would like

correlated_subquery

SELECT user_id, fb_request_id 
FROM   monitor_requests mr 
WHERE  current_state = '#{MonitorRequest::DENIED}' 
AND    fb_id IS NULL 
AND    fb_name IS NULL 
AND    created_at < '#{1.week.ago}' 
AND    user_id IS NOT NULL 
AND    fb_request_id IS NOT NULL 
AND    EXISTS (SELECT * FROM monitor_requests WHERE current_state = '#{MonitorRequest::PENDING}' AND fb_request_id = mr.fb_request_id)

The Arel is unfortunately needlessly complex given that the outer query conditions don't need to use the alias in the raw SQL.
The alias is really only needed on the condition in the correlated subquery.
But you have to use mr_alias in the outer query or you get this Postgres error - 'PGError: ERROR: invalid reference to FROM-clause entry for table "monitor_requests"' Lame.