Version 3.19.28 - November 11, 2025

This is a 3.19 patch release with minor improvements and bug fixes

Features and Improvements

[#19140] - Result::formatJSON should offer a way to export NaN and Infinity values as strings [#19144] - Result::formatJSON should offer a way to configure the binary data encoding [#19149] - Result::formatXML should offer a way to configure NULL encoding [#19168] - Offer XMLFormat::arrayFormat flag to format arrays to use the PostgreSQL <element/> format [#19172] - Support binding a Result value as a MultisetDataType [#19200] - Add DSL.noPath() for dynamic path joins [#19245] - Code generation plugins should offer a way to configure a java.security.Provider

Bug Fixes

[#19130] - ParserImpl::parseHints shouldn't eager allocate its StringBuilder [#19134] - Parser doesn't recognise INT32 and INT64 data types [#19154] - Result::formatJSON doesn't put Interval types in double quotes [#19162] - NullPointerException in Result::intoXML when working with XML fields whose content is a text node [#19165] - Result::intoXML does not recurse into nested Formattables [#19175] - inline(null, multisetType) doesn't work [#19181] - KotlinGenerator produces Long instead of Long? type for java.lang.Long auto converter configurations [#19185] - Gradle code generation plugin cannot find orderProvider [#19193] - Select::$replace doesn't maintain SELECT .. INTO clause [#19197] - Add missing accessors and mutators for the INTO clause to Select [#19202] - Select::$traverse doesn't traverse into numerous clauses [#19209] - Support parsing multi dimensional array simplified syntaxes [#19231] - Cannot deserialise XML content from MULTISET XML emulation [#19235] - SQLDataType.XML should be bound as XMLTYPE, not as String in Oracle [#19238] - Code generator should call GeneratorStrategy::getJavaClassExtends with Mode.DAO [#19242] - SQLDataType.XML should be inlined using XMLPARSE(DOCUMENT ..), not as String in Db2 [#19252] - Result.into(ContentHandler) doesn't emit endElement() event for document element [#19258] - NTH_VALUE and LAST_VALUE $replace() implementation switches function to FIRST_VALUE [#19268] - AggregateFunction::$traverse doesn't traverse $withinGroupOrderBy() parts [#19271] - DefaultAggregateFunction::$traverse isn't implemented correctly [#19274] - Some aggregate functions traverse their contents twice in their $traverse() implementations [#19284] - Quantified comparison predicates produce illegal any[] cast when using Scala vararg splicing operators on generic typed sequences [#19296] - COUNT(table) emulation does not maintain FILTER or OVER clauses [#19302] - MetaImpl doesn't provide table comments for BigQuery [#19306] - BigQuery nested ROW emulation produces invalid column names [#19310] - BigQuery RECURSIVE CTE generates unnecessary derived table around UNION ALL query [#19318] - LIMIT clause taking expressions isn't emulated correctly for UNION queries, when QUALIFY has native support [#19322] - Diff undeterministically produces cyclic constraint or index rename statements for redundant constraints or indexes [#19338] - BigQuery doesn't support SIMILAR TO [#19351] - Upgrade Maven dependency to mitigate CVE-2025-48924