Skip to content
SQLAnvil

What's New

Release notes for the @sqlanvil/cli and @sqlanvil/core packages. Full notes live on GitHub Releases.

1.1.0 — Named connections + schema introspection

Section titled “1.1.0 — Named connections + schema introspection”

Read foreign sources declaratively, without hand-writing FDW boilerplate.

  • Named connections: define connections: in workflow_settings.yaml and tag a declaration with connection: — SQLAnvil auto-generates the read-only FDW bridge (BigQuery or Postgres source) and the table becomes ref()-able. warehouse: can name a connection; non-secret connection defs live in workflow_settings.yaml, secrets in .df-credentials.json. See the Foreign Data Wrappers guide.
  • sqlanvil introspect: reads a source table’s schema and writes the declaration with columnTypes (and descriptions) filled in, mapping source types to your warehouse dialect.
  • sqlanvil init now defaults to --warehouse supabase (was bigquery), fitting the Postgres/Supabase-first focus. Pass --warehouse postgres|bigquery to override.

1.0.3 — Cross-warehouse Foreign Data Wrappers

Section titled “1.0.3 — Cross-warehouse Foreign Data Wrappers”

First-class Foreign Data Wrapper support in the wrapper() action — query another warehouse in place and join it with your operational data.

  • Provider presets: wrapper({ provider: "bigquery", server, serverOptions, credential, foreignTables }) emits a complete, correct BigQuery FDW bridge (enables the wrappers extension, registers the FDW idempotently, creates the server). Generic FDW remains reachable on any Postgres via explicit wrapper/handler/validator.
  • Ref-able foreign tables: each foreignTables[] entry becomes a ref()-able table that depends on the server setup, so downstream models consume external data like any other source.
  • Safe credentials: references a pre-existing Supabase Vault secret by id — the service-account key JSON never enters SQLAnvil. Postgres-first design; only the credential path is Supabase-specific.
  • New example: supabase_bigquery_mailing_list — a proximity mailing list joining Supabase orders with Google’s bigquery-public-data ZIP geo data via a live FDW + PostGIS.

See the Foreign Data Wrappers guide.

1.0.2 — Packaging fixes

Section titled “1.0.2 — Packaging fixes”
  • The published npm packages now include README.md, LICENSE, and NOTICE, so the npm package pages render the README and the Apache-2.0 license ships in the artifact.

1.0.0 — First public release

Section titled “1.0.0 — First public release”
  • Open-source SQL workflow tool for BigQuery, PostgreSQL, and Supabase, forked from Dataform OSS and extended with first-class Postgres/Supabase support.
  • Idiomatic Postgres DDL/DML (native partitioning, INSERT … ON CONFLICT upserts, btree/gin/gist/brin indexes, materialized views).
  • Supabase-native action types: RLS policies, Realtime publications, pgvector indexes.
  • Flat warehouse: config + gitignored .df-credentials.json connection.