SQLObject or SQLAlchemy?

[lazaridis_com]

Of course not.

You are right.

It's not relevant for _you_.

You may not know it but the R in ORM stands for Relational, which
actually implies a RDBMS.

....which is completely irrelevant to _me_.

Thus I'm looking for an ORM which decouples the "R" part nicely.

Once again, it has nothing to do with persistency. I can use an ORM
connected to an in-memory SQLite db.

What _you_ do is not _my_ use case.

I don't give a damn about your "personal preferences".

_You_ are not the central part of this topic.

_I_ am not the central part of this topic.

The OP asked for "personal preferences":

"I'm just wondering what everyone's preference is, and why, and if
there are even more choices for ORM."

I present my personal preferences here:

http://case.lazaridis.com/wiki/Persist

nothing special.
..