Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-27 Thread Pavel Velikhov
Let("sum_y", lambda y: sum(y), "y") # [name of the new var], function, > *[arguments to pass to the function] > ) > query.execute(x=range(1, 8), y=range(1, 7)) > or > query.execute(PgDatabase(**dbsettings)) > > -Brice > > Le 25/03/17 à 16:40, Kyle L

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Pavel Velikhov
Hi Nick! > On 26 Mar 2017, at 18:02, Nick Coghlan wrote: > > On 26 March 2017 at 21:40, Pavel Velikhov wrote: >> On 25 Mar 2017, at 19:40, Nick Coghlan wrote: >>> Right, the target audience here *isn't* folks who already know how to >>> construct their

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Pavel Velikhov
Hi Nick, Thanks for such a detailed response! > On 25 Mar 2017, at 19:40, Nick Coghlan wrote: > > First off, I think PythonQL (and PonyORM before it) is a very > interesting piece of technology. However, I think some of the answers > so far suggest we may need to discuss a couple of meta-iss

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Pavel Velikhov
leaving me wishing for >> LINQ-like language features. >> >> As an alternative to extending Python with PythonQL, Terry Reedy >> suggested interpreting a DSL string, and Pavel Velikhov alluded to using >> magic method tricks found in ORM libraries. I can see how both these

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Pavel Velikhov
Hi Michel! > On 25 Mar 2017, at 22:43, Michel Desmoulin wrote: > > Hello, > > I've been following PythonQL with interest. I like the clever hack using > Python encoding. It's definitely not something I would recommend to do > for an inclusion in Python as it hijack the Python encoding method, >

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Pavel Velikhov
is comfortable with SQL would prefer this > declarative approach. I could see myself using an API like this to search a > Pandas dataframe, for example. I think if we get this right, we might unlock some cool new usages. I really believe that if we simplify integration of multipl

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Pavel Velikhov
t;http://dask.pydata.org/en/latest/dataframe.html> > > So I think your burden is even higher than showing the usefulness of > PythonQL. You have to show why it's worth adding new syntax to do somewhat > LESS than is available in very widely used 3rd party tools that avoid new &

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-26 Thread Pavel Velikhov
> On 25 Mar 2017, at 15:51, Gerald Britton wrote: > > On 25 March 2017 at 11:24, Pavel Velikhov <http://gmail.com/>> wrote: > > No, the current solution is temporary because we just don’t have the > > manpower to > > implement the full thing: a real system

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-25 Thread Pavel Velikhov
Hi Paul! > On 25 March 2017 at 11:24, Pavel Velikhov wrote: >> No, the current solution is temporary because we just don’t have the >> manpower to >> implement the full thing: a real system that will rewrite parts of PythonQL >> queries and >> ship them to und

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-25 Thread Pavel Velikhov
gt; Side note : I might not have understood what you were doing, so if I'm > off-topic, tell me ! > > -Brice > Thanks for the feedback! This is very useful. > > Le 24/03/17 à 16:10, Pavel Velikhov a écrit : >> Hi folks! >> >> We started a project t

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-25 Thread Pavel Velikhov
> On 25 Mar 2017, at 02:19, Greg Ewing wrote: > > Terry Reedy wrote: >> PQL expressions should be quoted and passed to the dsl processor, as done >> with SQL and other DSLs. > > But embedding one language as quoted strings inside another > is a horrible way to program. > > I really like the i

Re: [Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-24 Thread Pavel Velikhov
Hi Terry! Thanks for your feedback, I have a couple comments below. > On 24 Mar 2017, at 20:50, Terry Reedy wrote: > > On 3/24/2017 11:10 AM, Pavel Velikhov wrote: >> Hi folks! >> >> We started a project to extend Python with a full-blown query language >>

[Python-ideas] Proposal: Query language extension to Python (PythonQL)

2017-03-24 Thread Pavel Velikhov
Hi folks! We started a project to extend Python with a full-blown query language about a year ago. The project is call PythonQL, the links are given below in the references section. We have implemented what is kind of an alpha version now, and gained some experience and insights about why and

Re: [Python-ideas] Query Language extension to Python

2016-11-02 Thread Pavel Velikhov
make nested queries easier to write and a few minor bells and whistles. > >> On Tuesday, November 1, 2016 at 2:03:44 PM UTC-5, Pavel Velikhov wrote: >> Hi David! >> >> I haven’t used blaze, but its looks quite similar to pandas, at least >> conceptually.

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread Pavel Velikhov
suppose. > On 1 Nov 2016, at 21:17, David Mertz wrote: > > How do you see this as different from Blaze > (http://blaze.readthedocs.io/en/latest/index.html > <http://blaze.readthedocs.io/en/latest/index.html>)? > A > > > On Nov 1, 2016 1:34 AM, &quo

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread Pavel Velikhov
lumn-expressions> > - https://github.com/cloudera/ibis/blob/master/ibis/sql/alchemy.py > <https://github.com/cloudera/ibis/blob/master/ibis/sql/alchemy.py> > > On Tuesday, November 1, 2016, Pavel Velikhov <mailto:pavel.velik...@gmail.com>> wrote: > Hi Folks, > >

[Python-ideas] Query Language extension to Python

2016-11-01 Thread Pavel Velikhov
Hi Folks, We have released PythonQL, a query language extension to Python (we have extended Python’s comprehensions with a full-fledged query language, drawing from the useful features of SQL, XQuery and JSONiq). Take a look at the project here: http://www.pythonql.org and lets us know what yo