If you create a class with related joins and use them,
the entries on the intermediate table won't be deleted
along with the object itself. I have found this really
Attached patch deletes these related join rows from all
objects refering to the object being destoyed and from
the joins of the object itself.
The patch is against SQLObject subversion head as of
9th November 2006.