github coldbox-modules/qb v12.0.0

latest releases: v13.0.7, v13.0.6, v13.0.5...
4 months ago

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, and sum (66ddd2e)
  • QueryUtils: Support sqltype alongside cfsqltype. (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 and SELECT ... INTO using schema.createAs method (1e138c1)
  • SqlServerGrammar: Add support for for clauses, to return JSON or XML from a query (eb3434b)
  • QueryBuilder: Add returningAll() method — shortcut for returning( "*" ) (1ae7521)
  • PostgresGrammar: Add jsonb() support (434c2c8)
  • MySQLGrammar: Use JSON type for json() 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 and paginate methods (12b7bfd)
  • DerbyGrammar: Use correct concat operator for DerbyGrammar
    (882aa7b)
  • PostgresGrammar: Use native UUID type for guid() (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)

Don't miss a new qb release

NewReleases is sending notifications on new releases.