• 原始 sql 语句如下:

select be.id, be.fullName1, be.workEmail
from employees as be
         left join id_mapping as ci
                   on be.id = ci.user_id
where be.id like '%Steven%'
   or be.fullName1 like '%Steven%'
   or be.workEmail like '%Steven%'
   or ci.new_id like '%Steven%'
group by be.id

• 研究了一下午,暂无头绪.先用 raw 运行着 sql 语句.
• 请各位出手相助.