Just for fun: WebQuery is YQL in Python
github.com
github.com
As of now, it only supports SELECT and does not do any caching. It's also slightly different from YQL in that it's actually SQL, and it uses a different definition format (it would be nice to support the Open Data Tables format, though).
What do you think?