Multiple relationship filtering on a single call

Hi everyone,

i am new to DF, trying to get around some standard sql queries like:

select id from table1 where id IN (select anotherid from table2 where somerules) and id NOT IN (select someotherid from table3 where someotherurles)

is there anyway to have this converted to df url filters ? If not what do you think is the best way to achieve the same result through DF rest api ?

I did try some virtual relationship and virtual fields but no luck so far.

Any help is appreciated.
Thank you