Changelog — strata-lang
Format: 0.1.x pre-1.0, feat/fix/chore per commit. Tag v0.1.0/v0.1.1 on origin.
0.1.1 — 2026-09-22
PyPI strata-lang 0.1.1 (sdist 215K + wheel 149K, twine PASSED)
pyproject.toml:8license {text}+classifier→license="MIT"+license-files=["LICENSE*"](setuptools≥77, removes deprecation2027-02-18that brokebuildinf838337).strata/__init__.py:30.1.0→0.1.1sync..github/workflows/publish.yml:1on: tag v*→build sdist+wheel→pypa/gh-action-pypi-publishOIDC trusted publishing (environment: pypi) +gh-releasewithdist/*+ SLSA attestations. Requires Trusted publisher on PyPI (Tzinny-dev/strata/publish.yml/pypi).- Verified
strata_lang-0.1.1.tar.gz+whlon PyPI,gh release v0.1.1with both assets.
0.1.0 — 2026-09-22
First release strata-lang 0.1.0 (PyPI + GH Release + Docker)
- Packaging:
pyproject.toml:1name strata-lang(strataalready taken 2013 byclastic),console_scripts strata=cli:mainpyproject.toml:50,extras postgres/bigquery/snowflake/airflow/prefect/portalocker,README.md:19pip install strata-lang+uv tool install strata-lang,.gitignore:26dist/build/*.egg-info,LICENSE MIT, wheel149Ktwine PASSED. - CI:
.github/workflows/ci.yml:1matrix3.10-3.12+postgresql-16(pg_harnessephemeral),pip install -e .[dev]+pytest --cov-fail-under=80(650+ passed 81%). - Warehouse honesty:
docs/warehouse-adapters.md:114-col table (adapter ABC vs enginecli.open_warehousedbcompat.PGConn),adapters.py:103honestE095(postgres withoutWarehouseABC yet,bigquery/snowflakesql-emit only),README.md:57aligned. - Stubs:
integrations.py:1scaffolding only,testing.py:1fixture helpers,observability.py:1connected (exec.py:27MetricsCollector). - Fix 3.10:
tests/test_warehouse_partition_freshness.py:44f"..., {", ".join→f"..., {', '.join(PEP 701,e8dec1d,ci 3.10SyntaxError). - Docker:
Dockerfile:1python:3.12-slimpip install strata-lang[postgres]==0.1.0,.dockerignore,.github/workflows/docker.yml:1on tag v*buildx+GHCRstrata:0.1.0/latest.
Binary standalone — Phase 0-4 (2026-09-22)
Documented docs/binary-standalone.md:1.
- Phase 0 prep
5572426:exec.py:11fcntl→try/except ImportError+portalockerfallback + single warning (plan-hito-2.md:159Windows),bench.py:26_bench_dir()sys.frozen/_MEIPASS,pyproject.toml:32extraportalocker. - Phase 1 POC
0cc832c:strata_entry.py:1absolute entry +strata.spec:4onefilehiddenimports duckdb/psycopg2/yaml/strata.*,datas examples+bench,upx True→dist/strata 34M(_duckdb.so 58M→34Mcompressed), smokehelp/build/compile postgres/run --seed 3 rows/bench all green. - Phase 2 CI
f88769d:.github/workflows/binary.yml:1matrixubuntu/macos/windowssetup-python 3.12pyinstaller strata.spec, smoke 4 commands,upload-artifactper OS,releasemergesELF/Mach-O/.exe→strata-linux/macos/windows-amd64. - Phase 3 hardening
6dedf62:strata.spec:4addsLICENSE+READMEto the bundle,binary.yml:34upx-uclon ubuntu +sha256sum+ gate>120Mwarn,codesign --sign -ad-hoc macOS,attest-build-provenanceSLSA. - Phase 4 distribution
3374913:install.sh:1curl|bashdetects OS/arch, pullGH Releases v$VERSION/strata-*,homebrew/strata-lang.rb:1tap formula (version 0.1.1REPLACE_SHA256),README.md:72Standalone binary section, attest already in Phase 3.
0.1.2 — 2026-09-23
Binary standalone debt closed Phase 0-4 → production
docs/binary-standalone.md:1rewritten: from "requirements analysis / do not build" to implemented state34M+ remaining debt documented (real signing, auto SHA, parity, compat, arm64).binary.yml:185release now patcheshomebrew/strata-lang.rb:7version+REPLACE_*SHA256and commits[skip ci]tomain.binary.yml:103gatebinary vs pip parity(builddiff +bench+test --seed) only onubuntu-latest.binary.yml:140+strata.spec:33conditional UPX + jobcompatubuntu:20.04via Docker (glibc 2.31).install.sh:33arm64 detects nativestrata-*-arm64or falls back toamd64with a Rosetta/qemu warning;binary.yml:buildarm64 matrix commented out, ready (macos-14/ubuntu-24.04-arm).binary.yml:88prod signing documentedcodesign + notarytool/signtoolwithsecrets.APPLE_CERT/WINDOWS_CERT.
0.1.3 — 2026-09-23
Fix binary compat + release collision
binary.yml:11ubuntu-latest→ubuntu-22.04(GLIBC 2.38 on 24.04 breaksubuntu:20.042.31 — probeFailed to load libpython3.12.so.1.0),compat22.04 OK+20.04 probe warncontinue-on-error.binary.yml:185download-artifactmerge-multiple true→pattern strata-* false(collisionstratalinux/macos overwrote one — that's whyv0.1.2was missingmacosandb66bd0aended up withsha ""),b66bd0ahotfixsha 32a9...+ manual uploadmacos-amd64(arm64) tov0.1.2.homebrew/strata-lang.rb:8b66bd0afixed,install.sh:33+binary.yml:30c321d/4774bf3already inmain.
0.1.4 — 2026-09-23
VS Code extension + sync
vscode/package.json:2strata-lang→strata-tzinnydisplayName Strata→Strata — Tzinny(Marketplace was blockingstrata-langbyprabathkumarandStratabyStrataTeam),vscode 0.1.4publishedTzinny-dev.strata-tzinny(vsce 4.0Node 24segfault → web Uploadvsix 6.07K).strata/cli.py:1315cmd_lsp+cli.py:1328parserlsp(already documentedcli.py:50but not wired) +strata.spec:14hiddenimport strata.lsp.- Sync
pyproject.toml:7strata-lang 0.1.3→0.1.4(strata/__init__.py:3),README.md:810.1.1→0.1.4,Docker 0.1.0→0.1.4,guide/binary-standalone.md:30.1.1→0.1.4. vscode/README.md0.1.3→0.1.4+strata-tzinny-0.1.4.vsix+Tzinny-dev.strata-tzinny.
0.1.5 — 2026-09-23
B1 real BigQuery/Snowflake adapters
strata/dbcompat.py:70BigQueryConn/SnowflakeConn(chainingexecute→fetchalllikePGConn,?inlining for BQ,%sfor SF,db_schema/live_view_defs/physical_schema/physical_typesdispatch for the 4 dialects).strata/adapters.py:113BigQueryWarehouse/SnowflakeWarehouse(WrapsBigQueryConn/SnowflakeConn,materializeCREATE OR REPLACE TABLE,get_adapter("bigquery"/"snowflake")no longerE095when the driver is installed).strata/cli.py:42open_warehousenowbigquery://project/dataset?location=US→BigQueryConnandsnowflake://user:pass@account/db/schema?warehouse=WH&role=ROLE→SnowflakeConn.strata.spec:14hiddenimportsgoogle.cloud.bigquery/snowflake.connector.- Tests
tests/test_adapters.py:60+5mocks (BigQuery/Snowflakeget_adapter+open_warehouseURL),620+ passed(was516).
0.1.6 — 2026-10-09
BigQuery/Snowflake integration CI green (real emulators, no mocks)
.github/workflows/bigquery-snowflake.yml:1rewritten: no Cloud SDK install (gcloud emulators bigquerydoes not exist;google-cloud-sdkapt has no candidate on 24.04), no emulator setup steps (the harness owns them),--no-covon all 4 pytest runs (pyproject.toml--cov-fail-under=80fails single-file runs), job-levelenv:gating for the GCP auth step (secretsare invalid inif:).tests/bq_harness.py:1goccy emulator via Docker (ghcr.io/goccy/bigquery-emulator:latest, REST 9050):EmulatorBigQueryConntalks rawjobs.query(client.query().result()routes DDL/DML viaPOST /jobs→ 409 hang;create_dataset()hangs too — both bypassed); rewrites 3-part→2-part refs (goccy can't resolve`project.dataset`.t),NUMERIC(38,2)→NUMERIC(ZetaSQL caps P at 31), bare DDL targets qualified with the dataset; retry-on-startup-race before failing.tests/sf_harness.py:1dedicatedlocalstack/snowflake:latestimage (notlocalstack/localstack+SERVICES), hostsnowflake.localhost.localstack.cloud, requiresLOCALSTACK_AUTH_TOKEN(licensed) — skips cleanly without it.tests/test_sqlgen_bigquery.py:21+tests/test_sqlgen_snowflake.py:21models rewritten to parseable Strata (canonicalgroup { } ( aggregate { } )+coalesce; the parser has nois not nulland no bare select items — real product gaps, documented not fixed).tests/test_exec_bigquery.py:697 engine testsxfailwith reason:strata/exec.py:1206source_fingerprintsemits Postgres-only SQL ("s",to_json(t)::TEXT) rejected by BigQuery — fails on real BQ too, pending product fix.- Suite:
744 passed, 5 skipped, 7 xfailed(81%);ci.ymlmatrix3.10/3.11/3.12green;bigquery-snowflake.ymlgreen (BQ 1 passed + 7 xfailed, SF skipped without token).
Iceberg L1–L4 + import-dbt (in main, ships in 0.1.6)
Pending product:
Icebergpropuesta-iceberg.md(L1–L4 ✅, REST catalog no-go documented §10.5),WASMdiscarded.strata run --iceberg-dir <catalog>→ real Iceberg publication (L1) (strata/cli.py:358cmd_run, newstrata/iceberg.py): after a run that freezes snapshot tables (snap_<run_id>_<model>), each one is copied to<catalog>/runs/<run_id>/<model>as a real Apache Iceberg table viaCOPY ... (FORMAT iceberg)(DuckDB extension, not a SQL dialect) and registered in<catalog>/_strata_manifest.json(run_id → {model: dir}, byte-for-byte deterministic, cumulative,default= latest). Fail-loud: no iceberg extension →E100before running (no side effects); missing snapshot / incomplete export → the manifest is not written (all-or-nothing).--dialect≠ duckdb +--iceberg-dir→E100. Verified: externaliceberg_scanreads the published table in a separate connection;645 passed(was529).Operational Iceberg catalog L2: replay/rollback/gc (
strata/iceberg.pyverify_catalog_run/rollback_run/gc_catalog,strata/cli.py):strata replay <file> --verify <run> --iceberg-diradditionally validates that the published tables are readable (iceberg_scan) and their count matches the snapshots (E082prior verify,E083unreadable catalog);strata rollback <file> --run <id> --iceberg-dirrepoints the manifestdefaultwithout deleting anything physical (immutable,E081run absent,E083not published);strata gc <file> --iceberg-dir [--keep N] [--keep-days D] [--apply]lists/protectsdefault+latest and deletes old dirs (E084). Recency by mtime of run dirs (the manifest usessort_keys) —650 passed(was534).Independent Iceberg catalog reader with
pyiceberg(L3) (strata/iceberg.pyensure_pyiceberg/verify_catalog_run_pyiceberg,strata/cli.py--verify-reader,pyproject.toml:34extraiceberg):strata replay <file> --verify <run> --iceberg-dir --verify-reader pyicebergverifies the published tables WITHOUT DuckDB (reads*.metadata.jsonviaStaticTable+pyarrowscan): if the catalog is standard Iceberg, any engine reads it; the reader does not trust the writer. Fail-loud:pyicebergmissing →IcebergUnavailable(E083) withpip install 'pyiceberg[pyarrow]'. By default--verify-reader duckdb(zero new deps); theicebergextra is optional and the interpreter without it runs 12 tests + 1 skip, with it 13/13 —652 passed+ 1 skip in the suite (was539).import-dbtCTEs (WITH cte AS (...)) → Strata helpers (strata/importdbt.py:417_split_with,:490_translate_sql): eachWITHis translated to a helper model without a contract{model}__{cte}that the main model reads viafrom(import_dbt_projectprepends them to its model). Forward references / unused CTE → inert helper, green build (630 passed).strata catalog— Iceberg catalog inspection (L2 §10.4) (strata/cli.pycmd_catalog):strata catalog <dir>lists published runs, models per run and marks thedefault(*);--jsonpages the manifest;--run <id> [--verify-reader duckdb|pyiceberg]shows rows per model without re-running (both readers match → independent cross-check of standard Iceberg). Fail-loud: no manifestE084; foreign runE081; broken readE083—660 passed(was541).import-dbtIceberg SQL compat (L4) (strata/importdbt.py_rewrite_dml_annotation/_iceberg_config_notes): the dbt-iceberg SQL constructs are translated to flat Strata —INSERT [OVERWRITE] INTO <t> <select>→ the select (deterministic recompute, the overwrite IS the model);MERGE INTO <t> [AS t] USING (<select>) [AS s] ON <equi-keys> WHEN MATCHED THEN UPDATE ... WHEN NOT MATCHED THEN INSERT ...→ the select of the USING +dedup by <keys>;config(materialized/unique_key/partition_by/ttl_days)→// dbt-iceberg ...annotations (v1 writes unpartitioned, §4.2; ttl →strata gc --iceberg-dir --keep-days). Fail-loud E042 (no semantic drift): DELETE actions, USING without parentheses, ON not an equi-join,outside a target.is legal ONLY as a DML target (the dispatcher runs before the jinja strip). Verified green build artifact + byte-identical —669 passed+ 2 skip (was545).
Generated from git log --oneline 7376003..3374913 and pyproject.toml / strata.spec / binary.yml.