- Add mssql dialect. A huge effort by @igalklebanov ❤️ #595
- Add postgres
json_agg
andto_json
functions to function module - Add
is distinct from
operator #673 - Add
set('first_name', 'Jennifer')
variant for update query'sset
method #672 - Add
as
statement support for createTable #771. Thank you @viraxslot ❤️ - Add
nulls not distinct
option for constraints #770. Thank you @viraxslot ❤️ - Add
addIndex
&dropIndex
@ AlterTableBuilder #720. Thank you @Gaspero - Add
stream()
support for sqlite dialect #754. Thank you @tgriesser ❤️ - Fix query and error logging both occur on error. #796. Thank you @igalklebanov ❤️
- Fix type issue with
$if
#793. Thank you @igalklebanov ❤️ - Fix issue where
onConflict..doUpdateSet
used select types instead of update types. #792. Thank you @igalklebanov ❤️ - Add
eb.jsonPath<$>
#791. Thank you @igalklebanov ❤️ $narrowType
supports new type tagNotNull
for an easier way to mark columns not nullable manually- Fix #811
- Support arbitrary expressions in
min
andmax
aggregate functions.
Breaking changes
selectNoFrom
is removed fromExpressionBuilder
due to severe typescript performance issues.selectNoFrom
still exists in theKysely
instance, and in most cases, you can use that instead. See this example on how to migrate: https://kyse.link/?p=s&i=sqAZIvTQktxgXYzHGkqX.- Types are once again a little bit stricter in some places. You might get type errors from code like
where('first_name', '=', sql`something`)
. You need to explicitly give a type for thesql
expressions like thissql<string>`something`
- Deprecated functions
eb.cmpr
andeb.bxp
have been removed. Useeb
as a function instead.