[pysqlite] Taking column affinity into account

Dear All,


Is there any possibility to use the column affinity in adapters?
E.g. when storing datetime.date (1999, 12, 31) generate
"1999-12-31" if the column affinity is TEXT but "19991231"
if the column affinity is INTEGER?

I assume this is impossible in out of the box pysqlite, but
I'm wondering how easy or hard it may be, to add this functionality.

The corollary would be creating a mechanism for converters,
to let them know about the actual SQLITE data type.


Regards,
Peter