BREAKING
- QueryUtils: Remove
autoAddScale
setting (db178d1) - QueryUtils: Remove
strictDateDetection
setting (c3cb496) - QueryUtils: Remove
autoDeriveNumericType
setting (3259cf3) - QueryBuilder: Allow for default values for
max
,min
,count
, andsum
(66ddd2e) - QueryUtils: Support
sqltype
alongsidecfsqltype
. (a13a54f) - QueryUtils: Add new
convertEmptyStringsToNull
flag. (021a432)
chore
- CI: Disable adobe@2025 while we determine why it won't start in CI but starts locally
(d461d0e) - CI: Fix CI for BoxLang and ACF@2025
(76beca3) - CI: Fill out test matrix across workflows
(303bea0) - CI: Fill out better test matrix
(96970a9) - QueryUtils: Default
convertEmptyStringsToNull
to true
(7836576) - CI: Add different server.json files for each engine combination
(17e22dd)
feat
- SchemaBuilder: Add support for
CREATE TABLE ... AS
andSELECT ... INTO
usingschema.createAs
method (1e138c1) - SqlServerGrammar: Add support for for clauses, to return JSON or XML from a query (eb3434b)
- QueryBuilder: Add
returningAll()
method — shortcut forreturning( "*" )
(1ae7521) - PostgresGrammar: Add
jsonb()
support (434c2c8) - MySQLGrammar: Use
JSON
type forjson()
columns (6784932) - QueryBuilder:
.orderByRandom()
method (a2f6698) - SchemaBuilder: Add
truncate
method (d756709) - QueryBuilder: Allow restricting the delete unmatched clause in
upsert
(d5c0ac7) - QueryBuilder: Support queries without a FROM clause (c6ea79b)
- DerbyGrammar: Add Derby support
(57032c0)
fix
- compat: More compat fixes for BoxLang and ACF
(d0ba99d) - compat: Use more complicated method to determine pure BoxLang mode
(0dd3269) - compat: BoxLang@1 compatibility
(2541fe0) - compat: Fix issues in ACF@2021
(95965bc) - QueryBuilder: Fix count call for
chunk
andpaginate
methods (12b7bfd) - DerbyGrammar: Use correct concat operator for
DerbyGrammar
(882aa7b) - PostgresGrammar: Use native
UUID
type forguid()
(3b8f89f) - OracleGrammar: Support Unicode versions of column types (0bc959e)
- QueryBuilder: Fix for UPDATE clauses with JOINS and RETURNING (8db4177)
perf
- QueryBuilder: Improve performance for exists queries (07091d9)