Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
@aiparlance/sql — role schema, score 19/23, pass/partial/fail objectives
| Package | @aiparlance/sql |
| CLI | aip emit sql |
| Role | schema |
| Score | 19/23 (83%) |
| Band | Happy-path ready |
| Scorecard | transpilers/sql/EMITTER_OBJECTIVES.md |
| ✅ Pass | ⚠️ Partial | ❌ Fail | ➖ N/A |
|---|---|---|---|
| 19 | 0 | 4 | 32 |
CREATE TABLE, indexes, seeds, email as CITEXT, soft-delete {table}_active views, and versioned init migrations (0001_init.up/down via aip emit sql --migrations).
| ID | Objective |
|---|---|
A1, A4–A9 | Tables, enums, FKs, id/timestamps, soft-delete column + active views |
B1, B2, B4 | NOT NULL, UNIQUE, email → CITEXT |
C1–C6 | DDL, indexes, seeds, up/down migrations, postgres target |
H3–H5 | Goldens / CI / naming |
| ID | Objective |
|---|---|
B3 | CHECKs from validation { } beyond UNIQUE/required |
C7 | Transactions for multi-statement / workflow writes |
H1, H2 | COMMENT ON / fixture SQL |
npm test
node packages/cli/dist/cli.js emit sql examples/blog-crud.aip
node packages/cli/dist/cli.js emit sql --migrations examples/blog-crud.aip