using converters, adapters in sqlite3

[matthewperpick]

hello,

i want to make use of sqlite3's "adapter" and "converter" capabilities
but my classes are more complex than the point examples in the python
documentation (http://docs.python.org/lib/node347.html), because they
include foreign keys to othe rtables.

I don't want to concatenate those with the class' other data in one
column because then I lose the ability to filter data by FK in my
select queries.

so .. I was hoping someone could show me how to write converters &
adapters that will allow me to each attribute in its own column.

Thanks very much,

Matt