Skip to content

Refactor SQL tooling and create ops submodule. Support for MySQL and Bigquery.

Compare
Choose a tag to compare
@machow machow released this 19 Dec 03:36
· 262 commits to main since this release
44b291c

This is an alpha release for v1.0.0. There will likely be extensive changes through January as I work to refactor the core API.

Big changes

  • Added ops submodule (and removed spec submodule).
    • This contains generic functions for pandas methods.
    • Has method data needed to translate pandas expressions to SQL (e.g. whether something is a property, or uses an accessor).
  • Refactored SQL translation mechanism:
    • Base dialect that others extend.
    • Over clauses in translate.py now have a func class method. This generates a constructor for a specific sql translation.
    • Now uses a pandas translator from ops submodule.

Features:

  • Support bigquery as a SQL dialect (#322)
  • Support MySQL as a SQL dialect. (a9b97a9)
  • ci: add test deployment to action (#354)