Skip to content

Releases: takaebato/sql-insight

sql-insight-v0.3.0

Choose a tag to compare

@github-actions github-actions released this 28 Jun 11:09
e609677

Added

  • bucket REPLACE / INSERT OVERWRITE as Create + Delete in CRUD by @takaebato in #36
  • add Catalog::from_ddl_with_casing for casing-override alignment by @takaebato in #36
  • fan in NATURAL JOIN merge columns (catalog-aware) by @takaebato in #36
  • count GROUP BY / ORDER BY positional ordinals as reads by @takaebato in #35
  • flag INSERT/MERGE arity mismatches for VALUES and column-less sources by @takaebato in #35
  • carry catalog resolution on written columns and lineage targets by @takaebato in #34
  • read the LIKE / CLONE shape source; CLONE feeds lineage by @takaebato in #34
  • carry catalog resolution on write targets (TableWrite) by @takaebato in #34
  • implement operator extraction: table & column lineage from SQL by @takaebato in #31
  • normalize column lists, nested IN expressions, and unary operators by @piki in #7

Fixed

  • correct extraction edge cases in CTEs, DML targets, lineage, and catalog (#37) by @takaebato in #37
  • don't duplicate a recursive CTE's anchor diagnostics by @takaebato in #36
  • flag a non-table UPDATE target instead of dropping it silently by @takaebato in #36
  • normalize a TOP constant quantity by @takaebato in #36
  • flow the WITHIN GROUP value of an ordered-set aggregate by @takaebato in #36
  • treat a parameterized FROM function as an opaque table factor by @takaebato in #35
  • extract tuple SET (a, b) = … assignments by @takaebato in #35
  • flow the LHS of IN (subquery) in value position by @takaebato in #35
  • bind DELETE/UPDATE ORDER BY and LIMIT clauses by @takaebato in #35
  • extract wildcard REPLACE (expr AS col) outputs by @takaebato in #35
  • extract MERGE RETURNING / OUTPUT columns by @takaebato in #35
  • bind QUALIFY against the post-projection scope by @takaebato in #35
  • model DML reads as a data-flow source/sink split by @takaebato in #34
  • attribute a multi-table UPDATE's SET targets to their own tables by @takaebato in #34
  • extraction correctness pass: reads / lineage / DML classification / catalog, + binder refactors by @takaebato in #33

Documentation

  • note that normalization replaces all literals, including structural ones by @takaebato in #35

Other Changes

  • add PR-title lint and release-plz release automation (#40) by @takaebato in #40
  • cover untested SQL constructs and public reference conversions by @takaebato in #35
  • remove the redundant flat table extractor by @takaebato in #34
  • migrate extractor/mod.rs to extractor.rs (#25) by @takaebato in #25
  • upgrade sqlparser to 0.61.0 by @takaebato in #23
  • upgrade sqlparser dependency to 0.56.0 by @piki in #9

v0.2.0

Choose a tag to compare

@takaebato takaebato released this 04 Jul 15:17

What's Changed

  • Add unify_values option to normalization (and update tarpaulin to v0.30.0) by @takaebato in #6

Full Changelog: v0.1.1...v0.2.0

v0.1.1

Choose a tag to compare

@takaebato takaebato released this 12 Feb 14:33

What's Changed

Full Changelog: v0.1.0...v0.1.1

v0.1.0

Choose a tag to compare

@takaebato takaebato released this 12 Feb 11:40

Initial release.