[Seaside] ROE, anyone?

[Brian Brown]

Happy new year all!

After a 6 month hiatus, I'm back doing some seaside work, and am  
using ROE to access a preexistent database. I have a need to be able  
to select records based on the month and the year in a datetime  
field, but there doesn't seem to be any way to use SQL functions such  
as SUM(), MAX(), MONTH(), YEAR(), etc....  I tried to figure out how  
to add something like that, but failed quite miserably!

Anyone have any thoughts, ideas, pointers, etc.?

thanks!

Brian