Refactor SQL tooling and create ops submodule. Support for MySQL and Bigquery.
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 removedspec
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.