KarpelesLab / psql / 22833269558

push

github

Add PostgreSQL-focused features: ILike, IsDuplicate, upsert, RETURNING, subqueries, typed slices

- ILike: case-insensitive LIKE (ILIKE on PG, COLLATE NOCASE on SQLite)
- IsDuplicate: detect unique constraint violations across MySQL/PG/SQLite
- Atomic counters: Incr/Decr/SetRaw for UPDATE SET expressions
- IN with typed slices: []int, []int64, etc. auto-expand to IN(...)
- Any wrapper: PG = ANY($1) array syntax, falls back to IN on others
- Subqueries in WHERE: *QueryBuilder as escapeValueCtxable + SubIn
- FOR UPDATE SKIP LOCKED / NOWAIT on builder and FetchOptions
- Fix INSERT rendering: (cols) VALUES (vals) for PG/SQLite, SET for MySQL
- Upsert builder: OnConflict/DoUpdate/DoNothing for all engines
- RETURNING support: scan-back into struct after Insert/Replace on PG
- RunQueryT/RunQueryTOne: generic typed scanning for JOIN queries

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

193 of 370 new or added lines in 10 files covered. (52.16%)

3121 of 4989 relevant lines covered (62.56%)

53.92 hits per line