Skip to content

Release notes v1.4.0

๐Ÿ“ฆ Version 1.4.0 โ€” Complete SQL Builder Suite

Released: 2025-05-22


โœจ Highlights

  • ๐Ÿ”ง Fully integrated builder suite:
  • SelectBuilder
  • InsertBuilder
  • UpdateBuilder
  • DeleteBuilder
  • UpsertBuilder
  • โœ… Semantic-aware NewCondition(...) with operator, type, and placeholder resolution
  • ๐Ÿ’ก Dialect-safe rendering with support for PostgreSQL, generic (?, $1, etc.)
  • ๐Ÿ” Full stage validation using AddStageError(...)
  • ๐Ÿงช 100% test coverage across all builders and helpers

๐Ÿ†• Features

  • New ParamBinder with offset-aware placeholder generation
  • Dialect interface includes SupportsReturning() check
  • Condition inference: parses status = active, id IN ?, BETWEEN ? AND ?
  • Field alias rejection in INSERT and UPSERT for correctness

๐Ÿงฉ Dialect-Aware Logic

  • InsertBuilder and UpsertBuilder align on internal placeholder binding
  • UpsertBuilder supports ON CONFLICT DO UPDATE and DO NOTHING
  • RETURNING clause only enabled if dialect.SupportsReturning() returns true

โœ… Test Coverage

100% test coverage in:

  • select.go, insert.go, update.go, delete.go, upsert.go
  • condition_helpers.go, condition_renderer.go, param_binder.go

๐Ÿ“Œ Tag

v1.4.0