Support Arquero to SQL query translation. about arquero HOT 3 CLOSED

Yes! @chanwutk has already taken this on as a project. Some of the required tasks include:

• Serialize Arquero verbs + expressions to an AST. This is already provided by the internal query(...).toAST() method!
• Analyze verbs, segment into SQL queries / sub-queries, likely using a SQL-specific intermediate representation / AST format.
• Analyze verbs + expressions to identify unsupported operations (or perform more complex transforms for operations that don't have a clean one-to-one mapping). Note this may be DB-specific in terms of what functions, aggregate functions, etc. are supported by a particular target engine.
• Generate SQL query code for the target DB engine.

In addition, Arquero could provide a convenient API for issuing queries and marshaling query results to return Arquero tables. The arquero-worker package suggests one model and starting point for this.

from arquero.

Awesome. I think @tmostak would be very excited to hear this.

from arquero.

As we don't plan to support SQL output in the core Arquero package, I'm going to close out this issue. Feedback or requests regarding Arquero query serialization (Query.toJSON(), Query.toAST(), etc.) should be raised in new issues. SQL translation is being explored by @chanwutk and others in the arquero-sql repository.

from arquero.