Summary
Implement schema introspection for primary key discovery and an atomic SQL DML generator (UPDATE, INSERT, DELETE) with optimistic concurrency control.
Requirements & Scope
- Schema introspection: automatically query PRIMARY KEY and UNIQUE constraints for the active table.
- Read-only safety guard: if no primary key exists (complex view or keyless table), display a clear Read-Only badge and disable mutations to prevent data corruption.
- DML Generator: generate parameterized UPDATE, INSERT, DELETE statements with optimistic concurrency checks (WHERE pk = ? AND col = old_val).
- Review SQL Changes Dialog: interactive modal displaying the exact SQL statements generated before committing.
- Atomic transaction execution (BEGIN -> queries -> COMMIT / ROLLBACK on error).
Reactions are currently unavailable
Summary
Implement schema introspection for primary key discovery and an atomic SQL DML generator (UPDATE, INSERT, DELETE) with optimistic concurrency control.
Requirements & Scope