[Dbix-class] Subquerys

[Moritz Onken]

How do I write this query in dbix-class syntax?

DELETE FROM chat
   WHERE ( chat.ID
     NOT IN (
       SELECT chat.ID FROM chat
         ORDER BY chat.time DESC LIMIT 0,20 ))

thanks