Skip to content

Latest commit

 

History

History
23 lines (12 loc) · 2.59 KB

File metadata and controls

23 lines (12 loc) · 2.59 KB

workers-qb

1.14.0

Minor Changes

  • #164 df6fb06 Thanks @G4brym! - Add orWhereNull, orWhereNotNull, orWhereBetween, orWhereNotBetween, orWhereLike, and orWhereNotLike convenience methods to SelectBuilder

  • #162 91d4cc1 Thanks @G4brym! - Add orWhere() method to SelectBuilder for building OR conditions in fluent query chains

  • #158 8d1e2ec Thanks @G4brym! - Add WHERE clause convenience methods to SelectBuilder: .when(), .whereNull(), .whereNotNull(), .whereBetween(), .whereNotBetween(), .whereLike(), .whereNotLike(), and .whereNotIn()

Patch Changes

  • #160 1ae866e Thanks @G4brym! - Fix falsy WHERE/HAVING params (false, 0, empty string) being silently dropped in update, delete, and select queries

  • #159 306e973 Thanks @G4brym! - Fix CROSS JOIN to not include spurious ON clause in generated SQL

  • #165 ed919f2 Thanks @fc221! - Fix PostgreSQL migrations to create the internal migrations table with PostgreSQL-compatible SQL and avoid unnecessary placeholder rewriting for queries without parameters.

  • #161 92675a9 Thanks @G4brym! - Fix PGQB incorrectly converting bare ? placeholders to $ instead of $1, $2, ... in PostgreSQL queries

  • #163 84b5d0f Thanks @G4brym! - Add optional otherwise callback to .when() for inline if/else query building