0.27.5

Hey 👋

Long-time community member and ambassador @thelinuxlich has joined the contributors club! 🏅

v0.28 is right around the corner! 👀

🚀 Features

• add modifyEnd to insert, update and delete query builders by @thelinuxlich in #871

PostgreSQL 🐘 / MySQL 🐬 / SQLite 📘

• Add orderBy clause support to aggregate function builder by @ivashog in #896

PostgreSQL 🐘 / MySQL 🐬

• Adds onReserveConnection to Postgres and MySQL dialect configs by @dcousineau in #996

PostgreSQL 🐘

• feat: add postgres range types by @kansson in #1086

MS SQL Server 🥅

• Add additional config options to MSSQL dialect by @tmrclark in #1073

🐞 Bugfixes

• Updated TraversedJSONPathBuilder.$castTo and .$notNull to support chaining with .as() by @cassus in #1139
• DeduplicateJoinsPlugin preserves order of joins by @sam-lewis-storyteq in #1156

📖 Documentation

• Migrate to new playground by @wirekang in #861
• Improve relations recipe by @koskimas in #1081
• Improve expressions recipe by @koskimas in #1083
• fix: References typo by @Alcas1 in #1092
• Fix docs for generatedAlwaysAs by @nikeee in #1113
• chore: fix some comments by @timesince in #1114
• added clickhouse and bigquery dialects by @maktouch in #1117
• docs: updated outdated links by @krijoh92 in #1125
• Update migrations.mdx by @tijptjik in #1122
• fix: Raw builder typos by @Alcas1 in #1148
• docs: support light mode. by @igalklebanov in #1177
• docs: fix weird default state showing dark and light elements. by @igalklebanov in #1179
• fix(docs): add missing import to migrations example script by @mxkxf in #1178
• docs: refresh quotes. by @igalklebanov in #1182
• docs: fix stackblitz theme out of sync. by @igalklebanov in #1183
• docs: rework features list. by @igalklebanov in #1185
• docs: MERGE examples by @igalklebanov in #1188
• docs: add prerequisites section in "getting started". by @igalklebanov in #1197
• Docs: fix typo by @remiposo in #1216
• chore: check jsdoc examples. by @igalklebanov in #1263
• chore: fix jsdoc errors and add some examples, pt. 1. by @igalklebanov in #1264
• chore: fix jsdoc errors and add some examples, pt. 2. by @igalklebanov in #1277
• docs: clarify that after rolling back a transaction the exception gets thrown again by @twiddler in #1266
• chore: fix jsdoc errors and add some examples, pt. 3. by @igalklebanov in #1279

📦 CICD & Tooling

• chore: bump dependencies by @igalklebanov in #1126
• chore: run prettier. by @igalklebanov in #1128
• ci: test against older TypeScript versions. by @igalklebanov in #1192
• chore: add conditional exports test. by @igalklebanov in #1207
• chore: add continuous preview releases. by @igalklebanov in #1219
• Create .renovaterc.json by @igalklebanov in 3f99090
• chore: test deno 2. by @igalklebanov in #1262
• chore: check jsdoc examples. by @igalklebanov in #1263

⚠️ Breaking Changes

🐤 New Contributors

• @thelinuxlich made their first contribution in #871
• @dcousineau made their first contribution in #996
• @kansson made their first contribution in #1086
• @Alcas1 made their first contribution in #1092
• @timesince made their first contribution in #1114
• @krijoh92 made their first contribution in #1125
• @tijptjik made their first contribution in #1122
• @cassus made their first contribution in #1139
• @sam-lewis-storyteq made their first contribution in #1156
• @ivashog made their first contribution in #896
• @mxkxf made their first contribution in #1178
• @remiposo made their first contribution in #1216
• @twiddler made their first contribution in #1266

Full Changelog: 0.27.4...master