I've got a couple of client shops running 1.9

We're looking to transition over to another system at the moment, because we want to stay with webforms. Nothing against MVC, its just that we have quite a lot of other code in webforms.

Is there a simple way to export product data in CSV or similar format. If not, is there is simple query or stored procedure I can run to at least give me this in a table, i can then easily write a script to dump that as CSV

I've checked the stored procs on 1.9 and there aren't many, and none seem to be able to do what i want... there are no views either.