v0.197.1

🧹 Chore

• Remove dbt-sqlserver dependencies (#4862) @izeigerman

v0.197.0

✨ Features

• Add support for dot env file to load variables from (#4840) @themisvaltinos
• Add support for Restatements on SCD Type 2 models (#4814) @themisvaltinos

🪲 Bug fixes

• Display_name should not exclude the default catalog when environment_suffix_target is set to CATALOG (#4821) @erindru
• Failure instead of neutral missing req approval (#4816) @eakmanrq
• (table_diff) Ignore unexpected arguments instead of throwing an error (#4846) @erindru
• Include the preview disclaimer in the backfill section of the plan explanation when appropriate (#4845) @izeigerman
• MSSQL merge should handle all columns being unique keys (#4842) @treysp

🧹 Chore

• Warn user about interval expansion only if the model is incremental (#4834) @izeigerman
• Fix find references lsp end to end tests (#4835) @themisvaltinos
• Bump sqlglot to v26.31.0 (#4831) @georgesittas
• Move dotenv is listed in dependencies (#4849) @themisvaltinos
• Add no-op extras for duckdb and motherduck (#4829) @treysp
• Enable testing for Python 3.13 (#4851) @izeigerman

👽 Other

• Publish to open vsx (#4807) @benfdking
• Test extension through code-server and in ci (#4827) @benfdking
• Make release vscode manual step (#4830) @benfdking
• Use bigger image for e2e (#4850) @benfdking
• Move all e2e vscode tests to run in ci (#4841) @benfdking

v0.196.4

✨ Features

• Add fixes to linting errors (#4800) @benfdking
• (vscode) Remove unused button (#4818) @benfdking

🪲 Bug fixes

• Push filter down to query for get_expired_environments (#4804) @VaggelisD
• Set default for append-newline flag to None (#4820) @kelsin
• Prevent formatting=false throwing an error (#4819) @erindru
• (vscode) Lineage on non model file (#4824) @benfdking

🧹 Chore

• Add branded model string types (#4808) @benfdking
• Add CLAUDE.md (#4817) @eakmanrq
• (doc) Fix the 'table_name' command in the table migration guide (#4815) @izeigerman
• Pin pygls to avoid issues (#4825) @benfdking
• Moving everything to node 20 (#4828) @benfdking
• Improve MSSQL merge performance (#4811) @treysp

👽 Other

• Improve final regex requirement (#4806) @benfdking
• Create release of vscode extension (#4765) @benfdking
• Vscode-env-var-docs (#4803) @sungchun12

v0.196.3

🪲 Bug fixes

• Support signals for Python models (#4797) @izeigerman
• (mssql) Update SQL keywords to uppercase for consistency (#4795) @mattiasthalen
• Propagation of snapshots with missing intervals into the physical layer update stage (#4801) @izeigerman

👽 Other

• New get started (#4793) @sungchun12
• Make regex for circle ci stricter (#4805) @benfdking

v0.196.2

🧹 Chore

• Add metadata_updated_snapshots to EvaluatablePlan (#4796) @crericha
• Chore(deps-dev): Bump eslint from 9.28.0 to 9.29.0 (#4798) @dependabot[bot]

v0.196.1

✨ Features

• (cicd_bot) Show models with uncategorized changes instead of a generic error (#4783) @erindru
• (duckdb) Add file systems configuration option (#4778) @mrjsj

🪲 Bug fixes

• (cicd_bot) When enable_deploy_command: true, dont show message about required approvers (#4782) @erindru
• Create a transaction and a session when migrating a snapshot (#4794) @izeigerman

🧹 Chore

• Fix backslash warning (#4791) @georgesittas

👽 Other

• Add interactive init to quickstart docs (#4736) @treysp

v0.196.0

✨ Features

• (lsp) Add rename functionality for CTEs in vscode (#4718) @themisvaltinos
• Interactive sqlmesh init (#4726) @treysp
• (vscode) Print env into terminal (#4789) @benfdking

🪲 Bug fixes

• (vscode) Passing any lineage error through (#4786) @benfdking
• (lsp) Return context error in case it failed (#4787) @benfdking
• Changes to before_all/after_all alone now trigger virtual updates (#4788) @themisvaltinos
• Simplify complex expressions when validating boolean pydantic fields (#4790) @georgesittas

🧹 Chore

• Do not log test results if there are no tests (#4785) @georgesittas

v0.195.0

✨ Features

• Allow virtual environments to be given dedicated catalogs (#4742) @erindru
• (vscode) Ability to stop server (#4775) @benfdking
• Add formatter options to render command (#4753) @georgesittas

🪲 Bug fixes

• Warn into a console when the run is blocked by environment updates (#4769) @izeigerman
• (vscode) Include process path env variable in passed path (#4770) @benfdking
• (lsp) Extend support for table references with columns (#4763) @themisvaltinos
• (vscode) On sign in, restart lsp (#4772) @benfdking
• (mssql) Properly quote table and views when dropping in mssql (#4773) @themisvaltinos

🧹 Chore

• Change get_expired_environments() to return EnvironmentSummary (#4774) @VaggelisD
• Fix dbt import to prevent cicd failures (#4781) @erindru
• Bump sqlglot to v26.30.0 (#4784) @georgesittas

v0.187.9

🧹 Chore

• Bump sqlglot to 26.26.2 @georgesittas

v0.194.1

✨ Features

• Use new tcloud sqlmesh_lsp call (#4762) @benfdking
• (vscode) .env file into python env (#4764) @benfdking

🪲 Bug fixes

• (vscode) Allow uv pip executable called through tcloud (#4766) @benfdking
• Fetch full environment object one a time to prevent loading all of them at once during restatement (#4768) @izeigerman

🧹 Chore

• Use engine_adapter.execute for statements in python model docs (#4754) @georgesittas
• Minor refactors in sqlmesh test output (#4755) @VaggelisD

👽 Other

• Warning about environment variables (#4761) @benfdking