Converting SQL Code To Python Code Query

[jim2007]

Thanks for that info Larz60+, I see you can't simply, have SQL code translated into Python Code, using SQLAlchemy ?

Code has to be executed, as part of querying a database etc. Because at the moment, I only want, direct translation of that SQL Code, to Python Code.

Eddie

It does not matter what language you pick, you will not be able to translate the artifact of SQL you posted into it because it’s copying data directly into a temp table on the server!

And executing this type of thing on a client could be problematic in any case if it’s a large data set since all you are doing is dragging data across the wire only to push it back over again.

If you tell us what you are trying to achieve, perhaps we can suggest a better way of achieving it.