- Multiple Database Connectivity: Supports connecting to different databases dynamically based on environment headers.
- Git-Managed Queries: All queries are stored and versioned in a Git-based YAML configuration file.
- Three API Types:
- DQL API - Handles read operations (SELECT queries).
- DML API - Manages insert, update, and delete operations.
- DML with Batch API - Allows bulk execution of DML statements.
- Secure Configuration: Uses environment-based credentials stored in a configuration service.
- Scalable Architecture: Designed to handle high transaction volumes with optimized query execution.