v0.0.6

   🚀 Features

• Lateral JOIN support (INNER JOIN LATERAL, LEFT JOIN LATERAL)  -  by @productdevbook and Claude Opus 4.6 (1M context) (430dc)
• ILIKE, NOT LIKE, NOT ILIKE, NOT BETWEEN operators  -  by @productdevbook and Claude Opus 4.6 (1M context) (991d0)
• Tuple comparisons for row-value expressions  -  by @productdevbook and Claude Opus 4.6 (1M context) (35198)
• Sql tagged template literal for ergonomic raw SQL  -  by @productdevbook and Claude Opus 4.6 (1M context) (2af21)
• BETWEEN SYMMETRIC for order-independent range checks  -  by @productdevbook and Claude Opus 4.6 (1M context) (62553)
• SumDistinct() and avgDistinct() aggregate functions  -  by @productdevbook and Claude Opus 4.6 (1M context) (ba804)
• Subquery in FROM (derived tables)  -  by @productdevbook and Claude Opus 4.6 (1M context) (9dd40)
• OrderBy and groupBy accept Expression in addition to column names  -  by @productdevbook and Claude Opus 4.6 (1M context) (02f1c)
• Clear methods for resetting query clauses  -  by @productdevbook and Claude Opus 4.6 (1M context) (f7fa3)
• IN subquery and NOT IN subquery on Col  -  by @productdevbook and Claude Opus 4.6 (1M context) (69e76)
• String_agg, array_agg with ORDER BY, aggOrderBy helper  -  by @productdevbook and Claude Opus 4.6 (1M context) (821e6)
• Expression comparisons on Col, neg(), GROUPS frame kind  -  by @productdevbook and Claude Opus 4.6 (1M context) (03e0a)
• Arithmetic operators add, sub, mul, div, mod  -  by @productdevbook and Claude Opus 4.6 (1M context) (c9aed)
• JsonAgg, toJson, jsonBuildObject helpers  -  by @productdevbook and Claude Opus 4.6 (1M context) (0bbdf)
• Variadic coalesce, IS DISTINCT FROM, $call, selectExprs  -  by @productdevbook and Claude Opus 4.6 (1M context) (595f0)
• ORDER BY and LIMIT on UPDATE and DELETE (MySQL)  -  by @productdevbook and Claude Opus 4.6 (1M context) (99eff)
• CrossJoinLateral, typed using/join on DELETE/UPDATE  -  by @productdevbook and Claude Opus 4.6 (1M context) (c3d90)
• Column-to-column comparisons + valuesMany batch insert  -  by @productdevbook and Claude Opus 4.6 (1M context) (9eb0d)
• Variadic and/or, rawExpr, gteExpr/lteExpr  -  by @productdevbook and Claude Opus 4.6 (1M context) (6c303)
• PG array operators (@>, <@, &&)  -  by @productdevbook and Claude Opus 4.6 (1M context) (6737a)
• OnConflictDoUpdateSet with plain object for ergonomic upsert  -  by @productdevbook and Claude Opus 4.6 (1M context) (8b0fd)

    View changes on GitHub