LINQ in Python

Question

Is there any LINQ-like project for Python that can automatically query XML files and/or RDBMS tables? The syntax does not have to be exactly like LINQ in C#, but hopefully close in a pythonic way.

Answer 1

If you are looking for an ORM then there is SQLAlchemy

Answer 2

Pynq implements expression trees:

http://wiki.github.com/heynemann/pynq

Microsoft created Linq (Language Integrated Query) using Expression trees, which is a math concept on how to parse operations into trees in a way that you can analyze the operations independently from the result.

Pynq is an implementation in Python of the Expression Tree theory and some of the providers. There will be more providers gradually, but Pynq will strive to make it as easy as possible to write your own provider.

Answer 3

I don't know much about Linq but you may be interested in this:

http://code.activestate.com/recipes/442447/

It allows using generator expressions to query an SQL database.

Answer 4

I'm not an expert, but the Dejavu people claims Dejavu makes much of what LINQ does, and did it way before LINQ. Could be worth checking out:

http://us.pycon.org/2009/conference/schedule/event/70/