raw sql mapping to class

[Flavio Silva]

Hello !

I'm developing a new process of extracting data from one database and writing to another, and believed that sqlalchemy has many features that can help me in the that.

Looking in the documentation, especifically, in the case of "Getting ORM results from Textual and Core Statements", in the examples it is used classes that are mapped to tables.

I've a situation, where i will build a complex query, returning a resulting that is not similar to any table.

I would like to execute the query and have it automatically mapped to a class, to make a manipulation of this data. It is a data transformation and enrichment, i'm doing a extraction, transformation of data.

It is possible to do it ?

How i can do it ?

Anyone has some example ?

Sorry for the beginner question, but was not so clear in the documentation if it possible.

Thanks,

Flávio