I am having trouble trying to translate the below SQL to Ecto.Query.
select * from orders where id in (select order_id from reports)
The closest I think I come is the below but the return result is incorrect,
from q in query,
where: fragment("id in (select order_id from reports)")
