0.27.3

Hey 👋

This release happened on 03/09/2024.

What's Changed

• add cast method to ExpressionBuilder. by @koskimas in 3df726f
• fix bug in ExtractTableAlias exposed by TypeScript 5.4. by @koskimas in e356951
• add MERGE query support. by @igalklebanov in #700
• introspect column comments by @maktouch in #842
• Fix MSSQL Table Introspection Duplicate Column by @timclark97 in #848
• implement additional query builder clear methods by @garymathews in #840
• Just add missing smallint support for addColumn() (SIMPLE_COLUMN_DATA_TYPES) by @hash0000 in #860
• Correct spelling mistake in the case example by @obax in #878
• [Docs] Update complex join example to better illustrate the options available (symmetry with where) by @MarkusWendorf in #883
• add IDENTITY column support. by @igalklebanov in #823
• Add LIMIT operator for update statements by @tbui17 in #885
• add FETCH clause support. by @igalklebanov in #822
• add TOP clause support. by @igalklebanov in #821

Breaking Changes:

• into is now optional in InsertQueryNode.
• table is now optional in UpdateQueryNode.
• column data types are now validated at runtime. This only affects users who passed unsupported strings in the past. In case Kysely doesn't offer built-in support for a specific data type, you should have then and still should use sql template tag.

New Contributors

• @maktouch made their first contribution in #842
• @timclark97 made their first contribution in #848
• @garymathews made their first contribution in #840
• @hash0000 made their first contribution in #860
• @obax made their first contribution in #878
• @tbui17 made their first contribution in #885

Full Changelog: 0.27.2...0.27.3