The Problem with ORM Abstraction
Many developers express frustration with ORM tooling, particularly around SQL migrations. The desire to work directly with SQL is common, yet existing solutions often fall short when handling testing, seeding, staging environments, and team onboarding.
A SQL-First Alternative
A new approach addresses these pain points without introducing additional abstractions. The tooling is built on Kysely, allowing developers to maintain typed queries while gaining support for stored procedures and table-valued parameters. The JavaScript/TypeScript layer remains responsible for IO coordination and business logic, with the database layer handling schema management.
Key features include:
- No domain-specific language (DSL)
- No code generation
- No subscription requirements
- Native SQL validation and debugging support
- Integration with visual database clients
Supporting AI Agents
The platform includes safeguards for AI agent interactions, with built-in skills, MCP support, and per-agent role configurations. This prevents automated processes from making destructive changes to production environments while enabling efficient development workflows.
Data Modeling and Schema Design
A separate tool, Ignatius, handles data modeling and planning. It supports multiple schema description formats, including IDEF1X with modern symbols, and is designed for iterative development. The markdown-based workflow allows developers to maintain context details for themselves and their LLM assistants.
Practical Benefits
This approach eliminates the translation layer between SQL and JavaScript, allowing developers to:
- Copy and debug SQL directly in visual clients
- Maintain full language server validation for SQL
- Use SQL migration files without additional wrappers
- Avoid the cognitive overhead of ORM method translation
Conclusion
The solution provides a middle ground between raw SQL management and full ORM tooling, serving developers who prefer direct database interaction while still offering TypeScript integration and modern development workflow support.
Top comments (0)