How to create "or" statements in the same table/field

[ibarrae]

Hi again 👋

I was wondering how could we create the following query?

select parent.* 
left join child on child.parent_id = parent.id 
where ((child.field > 5 and child.field < 2) or (child.field IS NULL))

I know that there's the "$or" key at the moment but it doesn't seem to do what we need 😢.

Thanks in advance again for the help!

[tanweerdev]

@ibarrae I think this kind of complex query cant be handled with fat_ecto. But if you have some proposal in mind, please do share