v0.209.0

✨ Features

• Decouple forward-only from change categorization (#5110) @izeigerman

🪲 Bug fixes

• Do not initialize a state sync for sqlmesh clean (#5103) @VaggelisD

🧹 Chore

• Fix dbt incremental predicates test (#5113) @themisvaltinos

v0.208.1

🪲 Bug fixes

• Revert "Fix: Use merge when updating auto restatements (#5016)" (#5108) @vchan

v0.208.0

✨ Features

• Add ui package to keep sharable components and utils (#5089) @mykalmax

🪲 Bug fixes

• Make gateway names case-insesitive (#5092) @izeigerman
• Support Paren expressions in EACH, REDUCE, etc macros (#5096) @izeigerman
• Dont normalize aliases in merge and when matched (#5014) @themisvaltinos
• Migrate schemas when deploying a metadata snapshot that was based on unpromoted forward-only snapshot (#5102) @izeigerman

🧹 Chore

• Introduce Claude subagents to the repo (#5093) @izeigerman
• Add private repo tests on pr (#4972) @eakmanrq

👽 Other

• Clarify note about interval-scoped audits for incremental by time (#5101) @treysp

v0.207.0

✨ Features

• Helper to find key in model block (#5079) @benfdking
• Lint rule no missing external will create file (#5078) @benfdking
• Handle additional pseudocolumn types in bigquery when resolving… (#5085) @z3z1ma

🪲 Bug fixes

• Normalize blueprint variables (#5045) @georgesittas
• (athena) Properly extend Athena dialect (#5077) @erindru
• Clean signal registry before loading signals for the given project (#5088) @z3z1ma
• Unit test CTE failures not being captured (#5081) @VaggelisD

🧹 Chore

• Bump sqlglot to 27.6.0 (#5090) @izeigerman

👽 Other

• Clarify multiple signals must all be true (#5086) @treysp

v0.197.7

🪲 Bug fixes

• Don't use SCD type 2 restatement logic in regular runs (#4976) @themisvaltinos

v0.206.1

✨ Features

• (vscode) Allow the lsp loaded to be specified (#5070) @benfdking

🪲 Bug fixes

• Resolve physical tables correctly when the query optimization is disabled for a model (#5074) @izeigerman

🧹 Chore

• (vscode) Reenabling tests (#5071) @benfdking
• (vscode) Enabling more tests (#5073) @benfdking

v0.206.0

✨ Features

• Add partitioning for ducklake databases (#5030) @treysp
• (vscode) Add test recognition to vscode (#5019) @benfdking
• Location in nomissingexternal models linting error (#5049) @benfdking
• (vscode) Adding ability to update columns (#5013) @benfdking
• Allow the linter to return fixes that affect other files (#5057) @benfdking
• Allow empty external models file (#5061) @benfdking
• No missing external model provides fix (#5058) @benfdking

🪲 Bug fixes

• Stopped server would just restart (#5051) @benfdking
• Inconsistent behaviour when a macro returns a list containing a single array vs multiple arrays (#5037) @erindru
• (vscode) Force lsp to be single worker (#5050) @benfdking
• (vscode) Improve registering of lsp in extension (#5056) @benfdking
• Table_naming_convention not passed in all cases (#5062) @erindru
• Respect the project configuration if the forward-only suffix was not set in the bot's config (#5064) @izeigerman

🧹 Chore

• Log rendered jinja right before parsing it to improve debugging (#5043) @georgesittas
• (vscode) Move tests to central temp dir creation (#5054) @benfdking
• Remove unused variable (#5055) @benfdking
• Print a deprecation warning in the sqlmesh ui command (#5046) @izeigerman
• (docs) Fix-broken-link-to-example-file (#5048) @gem7318
• Ensure ducklake testing artifact is under a tmp path (#5059) @georgesittas
• Pin dateparser version (#5063) @erindru
• Bump sqlglot to v27.5.1 (#5068) @georgesittas

👽 Other

• Fix syntax error in linter guide (#5052) @treysp
• (vscode) Be less aggressive in CI (#5053) @benfdking

v0.205.0

✨ Features

• Allow linter to return multiple violations (#5026) @benfdking
• Allow some control of table naming at the physical layer (#4982) @erindru

🪲 Bug fixes

• Suppor forward-only changes of model kinds under certain circumstances (#5028) @izeigerman
• Revert dbt full_refresh handling for incremental by time range models (#5031) @izeigerman

🛠️ Refactor

• (lsp) References now use paths (#5036) @benfdking
• (lsp) Move references to internal types (#5039) @benfdking

🧹 Chore

• Bump sqlglot to v27.4.1 (#5035) @georgesittas
• Fail if >1 migration scripts start with the same version (#5038) @georgesittas
• (vscode) Turn on trace to help debug (#5041) @benfdking

v0.197.6

🪲 Bug fixes

• Prevent snapshots with shared versions in dev environments from expanding restatement intervals for prod snapshots (#5025) @izeigerman
• Suppor forward-only changes of model kinds under certain circumstances (#5028) @izeigerman
• Revert dbt full_refresh handling for incremental by time range models (#5031) @izeigerman

v0.204.0

✨ Features

• Add support for pre, post, on_virtual_update statements in config (#4995) @themisvaltinos
• (lsp) References function now detects non registered external models (#5023) @benfdking

🪲 Bug fixes

• (table_diff) Correctly handle joins with composite keys where one or more of the key fields are null (#5007) @erindru
• (cicd_bot) Include namespace in deploy command hint (#5006) @erindru
• (lsp) Notification would now show (#5024) @benfdking
• Prevent snapshots with shared versions in dev environments from expanding restatement intervals for prod snapshots (#5025) @izeigerman
• Use merge when updating auto restatements (#5016) @vchan

🧹 Chore

• (vscode) Refactor tests (#5021) @benfdking
• Bump sqlglot to 27.4.0 (#5029) @vchan

👽 Other

• Fix table formatting (#5020) @benfdking