ORM layer

[David]

I am looking for an ORM for Python that fulfills a few simple needs.

- ability to support a number of backends (probably mysql and sqlite  
at present, csv a bonus)
- ability to be used easily from console python scripts, a bonus if I  
can add a simple web GUI later using some framework
- decent documentation a definite plus

I do not need:

- massively complex joins (I could write these myself if needed)
- something engineered for hundreds of tables, I have only a few and  
don't need overkill

Any recommendations?

David