Nested queries or stored procedures

Hello everybody!

Can somebody help with nested queries in revo such as "SELECT * FROM table WHERE some_date=(SELECT max(some_date) FROM table WHERE some_date <= now())"?
And is it possible to call stored procedures or functions with revo?

Thanks in advance.