[Dbix-class] Group by and more

[Rachel K Richard]

Hi everyone,
I have two questions:
I'm trying to do this type of query with DBIC:

select tagid, count(*) from seqtag group by tag

But I can't figure out how to do this with DBIC. If I was using CDBI I 
would just use a set_sql statement.

Which is my next question. Is there a similar feature in DBIC for 
running your own hard-coded SQL?

Thanks
Rachel