[Dbix-class] (relatively) complex WHERE: how to do?

[Alex Povolotsky]

Hello!

I have a table of allowed IP addresses, table of physical servers and 
table of virtual servers (jails).

Selection of allowed-and-unused IPs looks like

select * from our_ips where ipid not in (select ipid from server) and 
ipid not in (select ipid from jail);

What's the best way to do it with DBIx::Class?

Alex.