[web2py] query in DAL

[beto (R3)]

Hey guys:

Is there a way to do this query in DAL?

SELECT
    date, count(foo.items)
FROM
(
    SELECT
        logs.date, logs.items
    FROM logs
    WHERE
        extract(year from logs.date) = 2010)
    GROUP BY date, items
) AS foo, stock
WHERE
    stock.items = foo.items
GROUP by date

Any help would be appreciated.

thanks!