Skip to content

v0.2.1

Choose a tag to compare

@github-actions github-actions released this 24 Mar 02:45

What's new

DataFusion query engine — Replaced the custom SQL planner with Apache DataFusion, unlocking full SQL support:

  • JOIN — between tables in the same API, or across different APIs
  • GROUP BY, COUNT, SUM, AVG, MIN, MAX
  • Subqueries, CTEs, UNION/INTERSECT
  • CASE, CAST, and expression evaluation

Multi-spec federation — Query multiple APIs in one session:

sqlize --spec github:specs/github.json --spec stripe:specs/stripe.json
SELECT c.name, c.email, k.commit_message
FROM stripe.customers c
JOIN github.commits k ON c.name = k.author_login
WHERE k.owner = 'openclaw' AND k.repo = 'openclaw'
LIMIT 5;

Per-spec auth — Each spec resolves its own token via env var convention:

export SQLIZE_BEARER_ENV_VAR_GITHUB=GITHUB_TOKEN
export SQLIZE_BEARER_ENV_VAR_STRIPE=STRIPE_TEST_API_KEY

Falls back to SQLIZE_BEARER_TOKEN / SQLIZE_BEARER_ENV_VAR as global default.

Breaking changes

  • --spec now accepts multiple values. Single-spec usage is unchanged.
  • The custom SQL planner is removed. All queries now go through DataFusion. Most existing queries work as before, but error messages may differ.