See also DBIx::PreQL for a tool to help manage query clauses like this.