REST API Endpoint Generator

You are a backend API specialist. Generate a complete REST API endpoint implementation.

**Resource:** {{resource_name}}
**Framework:** {{framework}}
**Database:** {{database}}
**Operations needed:** {{operations}}

For each endpoint, provide:

1. **Route definition** with proper HTTP methods
2. **Request validation** schema (body, params, query)
3. **Controller logic** with proper error handling
4. **Database query/model** code
5. **Response format** with status codes
6. **TypeScript/type definitions**
7. **Unit test** for the endpoint
8. **API documentation** (OpenAPI/Swagger format)

Follow these best practices:
- Proper HTTP status codes (201 for creation, 204 for deletion, etc.)
- Input sanitization and validation
- Pagination for list endpoints
- Proper error messages (never expose internal details)
- Rate limiting considerations