v0.77.0

✨ Features

• Allow partial unit test expected column sets, improve error handling (#2226) @georgesittas
• Truncate comments to engine-specific maximum (#2238) @treysp
• Typed macros 2 (#2109) @z3z1ma

🪲 Bug fixes

• Recursively check for unknown data types (#2235) @eakmanrq
• Redshift explain verbose no where limit (#2239) @izeigerman
• The default start value in the CICD bot config (#2244) @izeigerman
• Manual categorization (#2197) @mykalmax
• Improve error display for failed plan (#2220) @mykalmax
• List existing data objects concurrently when creating snapshot tables (#2247) @izeigerman
• Airflow local deployment for the most recent Docker version on Mac (#2248) @izeigerman
• Configure duckdb with connector_config settings. (#2240) @crericha
• Adding of LIMIT 0 to union queries when generating a model CTAS query (#2250) @izeigerman
• Warn instead of error single catalog multiple catalogs (#2251) @eakmanrq

🧹 Chore

• Update the default start value in the CICD bot docs (#2246) @izeigerman
• Serialize engine integration tests (#2245) @eakmanrq
• Fix ci/cd (#2249) @eakmanrq
• Bump sqlglot to v22.4.0 (#2237) @georgesittas
• Isolate web tests (#2253) @eakmanrq
• Cleanup @tobymao
• Remove unused transactional file class (#2254) @eakmanrq

👽 Other

• Return files even if there is no SQLMesh context (#2230) @vchan
• Add nesting level error to FAQ (#2232) @treysp
• Update UI quickstart to reflect UI updates (#2234) @treysp
• Expose additional fields in PlanDagSpec (#2231) @andrew-sha
• Fixing typo in default connection method (#2243) @kellydunn