APIJSON is a no-code database API generator and object-relational mapping layer that automatically transforms relational database schemas into functional HTTP endpoints. It provides a system for generating CRUD operations and technical documentation without the need to write manual backend code.
The project is distinguished by its ability to allow clients to define custom JSON response structures and field aliases directly within the request. It features dynamic query translation that converts structured JSON parameters into optimized SQL for complex relational joins, subqueries, and data aggregation.
The platform covers a broad set of capabilities including role-based row-level security, automatic SQL injection prevention, and a development environment for API testing and mocking. It also provides utilities for automated regression testing and the generation of typed client code snippets.