Skip to content

v0.0.5

Choose a tag to compare

@github-actions github-actions released this 04 Apr 13:17
· 258 commits to main since this release

   🚀 Features

  • Add window functions, COUNT(DISTINCT), and SQL helper functions  -  by @productdevbook and Claude Opus 4.6 (1M context) (37574)
  • Multiple .where() calls with implicit AND  -  by @productdevbook and Claude Opus 4.6 (1M context) (c915f)
  • $if() conditional query building on all typed builders  -  by @productdevbook and Claude Opus 4.6 (1M context) (58d17)
  • Add INTERSECT ALL and EXCEPT ALL set operations  -  by @productdevbook and Claude Opus 4.6 (1M context) (8f214)
  • INSERT ... SELECT and DEFAULT VALUES support  -  by @productdevbook and Claude Opus 4.6 (1M context) (2e475)
  • FOR SHARE, SKIP LOCKED, NOWAIT row locking modes  -  by @productdevbook and Claude Opus 4.6 (1M context) (2850e)
  • MySQL ON DUPLICATE KEY UPDATE upsert support  -  by @productdevbook and Claude Opus 4.6 (1M context) (c4105)
  • DISTINCT ON (PostgreSQL-specific)  -  by @productdevbook and Claude Opus 4.6 (1M context) (d3b1d)
  • DELETE USING and JOIN in UPDATE/DELETE  -  by @productdevbook and Claude Opus 4.6 (1M context) (783ed)
  • SQLite INSERT OR IGNORE/REPLACE modes  -  by @productdevbook and Claude Opus 4.6 (1M context) (2b3cd)
  • ON CONFLICT ON CONSTRAINT name support  -  by @productdevbook and Claude Opus 4.6 (1M context) (2436f)
  • Aggregate FILTER (WHERE) clause support  -  by @productdevbook and Claude Opus 4.6 (1M context) (4b258)
  • EXPLAIN and EXPLAIN ANALYZE support  -  by @productdevbook and Claude Opus 4.6 (1M context) (e64a5)

   🐞 Bug Fixes

  • Remove minify, eliminate _chunks for tree-shakeable dist  -  by @productdevbook and Claude Opus 4.6 (1M context) (c7149)
  • Switch to transform build for proper tree-shaking  -  by @productdevbook and Claude Opus 4.6 (1M context) (3ee65)
    View changes on GitHub