I am in need of a lightweight way to store dictionaries of data into a database. What I need is something that:

1. Creates a database table from a simple type description (int, float, datetime etc)
2. Takes a dictionary object and inserts it into the database (including handling datetime objects!)
3. If possible: Can handle basic references, so the dictionary can reference other tables

I would prefer something that doesn't do a lot of magic. I just need an easy way to setup and get data into an SQL database.

What would you suggest? There seems to be a lot of ORM software around, but I find it hard to evaluate them.