Skip to content

v1.1 — Drivers, Flight SQL, Filter Groups

Latest

Choose a tag to compare

@ralfbecher ralfbecher released this 19 Mar 08:58
· 1 commit to main since this release
982ab3b

What's New

DB-API 2.0 Drivers

  • 7 database drivers: ob-duckdb, ob-postgres, ob-snowflake, ob-clickhouse, ob-databricks, ob-dremio, ob-bigquery
  • Shared ob-driver-core with OBML query compilation, YAML model detection, and PEP 249 exceptions

Arrow Flight SQL Server

  • ob-flight-extension — connect BI tools (DBeaver, Tableau, Power BI) directly to the semantic layer
  • Token-based authentication and catalog/schema discovery

Query Execution

  • POST /v1/query/execute — compile OBML and run SQL against live databases
  • Native DuckDB path with read_only=True for notebook compatibility

Filter Groups (AND/OR/NOT)

  • Recursive FilterGroup model with logic: and|or and negated: true support
  • Works at both measure-level (filters: list) and query-level (where:/having:)
  • Updated JSON schemas (obml-schema.json, query-schema.json)

dimensionsExclude Relaxed

  • Anti-join queries now work with any 2+ dimensions — no longer requires independent branches
  • CROSS JOIN x EXCEPT pattern works across star and snowflake schemas

Other Improvements

  • Qualified DataObject.Column references in WHERE filters with auto-join
  • description property on all OBML model objects
  • OSI converter roundtrip: preserve OBML-only properties in custom_extensions
  • TPC-H quickstart notebook with interactive examples
  • CFL: skip NULL padding for UNION ALL BY NAME dialects
  • Version bumped to 1.1.0

Stats

  • 539 tests (419 unit + 120 integration)
  • 148 files changed, ~15,700 lines added