title: Recursive CTE Query
body: <p>I am having an issue constructing the SQLAlchemy code required to produce the following raw SQL query.</p>
  
  <pre><code>WITH RECURSIVE recruiters AS (
      SELECT 
          recruiter.id
      FROM 
          recruiter
      JOIN 
          recruiter_member ON recruiter.id = recruiter_member.recruiter_id
      WHERE
          recruiter_member.user_id = 'f12c617a-415c-4f8c-add0-81a597545be8'
      UNION ALL
      SELECT 
          children.id
      FROM 
          recrutiers AS parents, 
          recruiter AS children
      WHERE 
          children.recruiter_id = parents.id
  )
  SELECT
      *
  FROM
      recruiters
  </code></pre>
  
  <p>The models here are <code>Recruiter</code> and <code>RecruiterMember</code>. I just can't seem to get the <code>UNION</code> right.</p>