ORMish view for row mapper

patient_room_view.sql

DROP VIEW IF EXISTS patient_room_view;
CREATE VIEW patient_room_view AS
SELECT 
	nt.room_number, 
	CASE 
  WHEN coalesce(jsonb_agg(tm.*) FILTER (WHERE tm.job_title = 'RN'), '{}') ->> 0 != '[null]' 
  THEN (coalesce(jsonb_agg(tm.*) FILTER (WHERE tm.job_title = 'RN'), '{}') ->> 0)::jsonb
	ELSE '{}' 
  END 
    AS nurse, 
	CASE 
  WHEN coalesce(jsonb_agg(tm.*) FILTER (WHERE tm.job_title = 'NA'), '{}') ->> 0 != '[null]' 
  THEN (coalesce(jsonb_agg(tm.*) FILTER (WHERE tm.job_title = 'NA'), '{}') ->> 0)::jsonb
	ELSE '{}' 
  END 
    AS assistant,
	row_to_json(prs.*)::jsonb AS status,
  row_number() OVER () AS id
FROM patient_room pr, patient_room_status prs
  JOIN nursing_team nt ON prs.room_number = nt.room_number
  LEFT JOIN team_member tm ON (nt.assistant_id = tm.team_member_id OR nt.nurse_id = tm.team_member_id)
GROUP BY prs.id, nt.id