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 Jan 17:06
· 261 commits to main since this release

⚠️ Note: this is a re-release of alpha v1.0.0a2 to be v0.1.0. This will allow users to easily install these releases using pip. Changelog copied below.

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)