0.27.4

Hey 👋

We've reached 100 contributors AND 1,000 pull requests since our last release! 🍾
Here's all the amazing work done since version 0.27.3...

🚀 Features

• Added clearGroupBy() by @dswbx in #921
• add objectStrategy option that allows to not mutate result objects/arrays @ ParseJSONResultsPlugin. by @igalklebanov in #953

PostgreSQL 🐘 / SQLite 📘

• Support table names in UpdateQueryBuilder.returningAll by @koskimas in f63327e

MySQL 🐬 / MS SQL Server 🥅

• add varbinary data type for mysql by @jonasbovyn in #812

PostgreSQL 🐘

• feat: add 'add column if not exists' for postgres by @MarkusWendorf in #900
• feat: add '?|' comparison operator by @alenap93 in #1006
• feat: add the starts-with postgres comparison operator by @boehs in #1029
• postgres introspection getTables handle partition tables as well. by @HeikoOsigus in #1034

MS SQL Server 🥅

• add OUTPUT clause support. by @igalklebanov in #828

🐞 Bugfixes

• move preventAwait to alter-column-builder.ts. by @igalklebanov in #1031
• fixes The type of eb in selectFrom(eb => ...) is wrong by @koskimas in 873671b
• fixes QueryCompilerError: Could not serialize value causes Kysely instance to fail later by @koskimas in a65a7f3
• fixes CamelCasePlugin messes up complex type mappings with setTypeParser by @koskimas in d45a8fa

PostgreSQL 🐘 / MS SQL Server 🥅

• Updating visitMergeQuery to join WhenNodes with a space by @gittgott in #940
• fix merge queries not being transformed. by @igalklebanov in #955
• fix InferResult not working for merge queries. by @igalklebanov in #902

PostgreSQL 🐘

• Fix typo on timetz regex by @dunkelbraun in #911

MS SQL Server 🥅

• fix MssqlDialect streaming not handling backpressure. by @igalklebanov in #1041
• fix Tedious v18 includes different TypeScript annotations by @igalklebanov in #1041
• handle connection errors @ MssqlDriver. by @igalklebanov in #1042

📖 Documentation

• fix complex join example by @koskimas in 9f836c4
• fix complex join example some more by @koskimas in 8f9038f
• fix complex insert example by @koskimas in ead3489
• improve subquery insert example by @koskimas in 0e194b0
• add not null assertion site example by @koskimas in 58ba4ae
• fix a bunch of untyped sql snippets in API doc examples by @koskimas in 64a56f9
• make it even more clear that table interfaces are not row types by @koskimas in 9485b44
• update outdated intro in kysely.dev by @koskimas in e84863d
• remove snyk badge. by @igalklebanov in 4326a91
• add CTE examples to site by @koskimas in d9a53cd1441e0854456e930eb628f5b03a34db93\
• fix SQLite import @ getting started. by @igalklebanov in #927
• capitalization, more environments @ README. by @igalklebanov in 6ab2155
• fixed docs for deno by @kolay-v in #938
• Added MySQL and MariaDB support information for relation recipes by @chriswep in #800
• Fix spelling, punctuation, grammar by @DePasqualeOrg in #969
• Fix typo (it's --> its) by @davidalber in #1000
• add logging documentation page by @JeromeBu in #1003
• Docs now reflect tedious support in Bun by @igalklebanov in #1018
• Docs: Fix typo by @devgru in #1025
• mention kysely-ctl in migrations section. by @igalklebanov in #1035
• docs: add comments for UpdateResult by @movahhedi in #993
• fix mssql createPerson example. by @igalklebanov in #1048
• docs: fix values example not compiling. by @igalklebanov in #1058
• fix typo incorrect by @zce in #1068

📦 CICD & Tooling

• migrate to docker compose v2. by @igalklebanov in #932
• ci: bumping actions and runtimes. by @igalklebanov in #942
• ci: drop node16 tests as it reached EOL. by @igalklebanov in 873ed5a
• remove docker-compose file version. by @igalklebanov in #966
• add node22 @ tests. by @igalklebanov in #964
• export all operation nodes, forever. by @igalklebanov in #972
• ci: bump bun, test mssql in bun. by @igalklebanov in #1022
• ci: install only chromium by @igalklebanov in #1043
• bump TypeScript to v5.5. by @igalklebanov in #965
• docs: bump docusaurus to v3. by @igalklebanov in #1050
• docs: remove remaining react imports. by @igalklebanov in #1057
• ci: split jobs. by @igalklebanov in #943

⚠️ Breaking Changes

🐤 New Contributors

• @dunkelbraun made their first contribution in #911
• @dswbx made their first contribution in #921
• @kolay-v made their first contribution in #938
• @chriswep made their first contribution in #800
• @jonasbovyn made their first contribution in #812
• @DePasqualeOrg made their first contribution in #969
• @davidalber made their first contribution in #1000
• @JeromeBu made their first contribution in #1003
• @alenap93 made their first contribution in #1006
• @devgru made their first contribution in #1025
• @boehs made their first contribution in #1029
• @HeikoOsigus made their first contribution in #1034
• @movahhedi made their first contribution in #993
• @zce made their first contribution in #1068

Full Changelog: 0.27.3...0.27.4