Skip to content

v0.2.0

Choose a tag to compare

@yeongseon yeongseon released this 12 Apr 07:32
· 108 commits to main since this release

Highlights

  • Full SQLAlchemy 2.0 dialect rewrite with dedicated compiler and type system
  • IN, BETWEEN, LIKE operator support in WHERE clauses
  • ORM support with DeclarativeBase
  • Schema inspection (get_table_names, get_columns, has_table)
  • Type mapping: String, Integer, Float, Boolean, Date, DateTime

Features

  • ExcelDialect with ExcelCompiler, ExcelDDLCompiler, ExcelTypeCompiler
  • ExcelIdentifierPreparer (no-quoting for Excel compatibility)
  • ExcelInspectionMixin for schema reflection
  • DDL metadata tracking via __excel_meta__ sheet
  • Whitespace normalization in do_execute()
  • Column alias stripping (visit_label)
  • Table prefix stripping (visit_column)

Breaking Changes

  • Requires excel-dbapi>=0.2.0
  • Complete dialect rewrite — internal APIs changed

Notes

  • Python 3.10+ required
  • SQLAlchemy 2.0+ required
  • supports_statement_cache = False (by design)