portablesql / psql / 22908785362

77%

push

github

Add EXISTS, CASE, COALESCE, GREATEST/LEAST, subquery JOINs, INSERT...SELECT

New expression types for the query builder:
- Exists()/NotExists() for subquery conditions in WHERE
- Case().When().Else() for CASE WHEN expressions
- Coalesce() with support for subquery arguments
- Greatest()/Least() with SQLite fallback to MAX/MIN
- SubTable() for derived tables in FROM/JOIN positions
- InsertSelect() public API for INSERT ... SELECT queries
- Join/LeftJoin/InnerJoin/RightJoin now accept subquery tables
- Fix INSERT_SELECT to not include dest table in FROM clause

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

129 of 148 new or added lines in 6 files covered. (87.16%)

3208 of 4273 relevant lines covered (75.08%)

127.45 hits per line