I'm pleased to share an update: a new major version (v2) has been developed, which addresses many of the considerations discussed in our community feedback. https://issues.apache.org/jira/browse/CALCITE-7300
https://lists.apache.org/thread/jvbpz7rp7w76gqmshtz3y6bhcftk41c5 CalciteRestAPIAdapter v2 - Major Release Repository: https://github.com/oalekseev/CalciteRestAPIAdapter-v2 Key Improvements in v2: Configuration & Schema Discovery OpenAPI-based configuration instead of XML - automatically discovers REST API schemas without manual field definitions FreeMarker templates for flexible HTTP request customization (body, headers, URL parameters) Supports complex nested structures and format transformations (JSON, XML, CSV) Advanced Filtering & Query Optimization DNF/CNF filter support - converts SQL WHERE clauses to Disjunctive/Conjunctive Normal Form for efficient REST API filtering Query pushdown - sends filtered data requests directly to REST services, reducing data transfer Comprehensive Test Coverage: 13 test classes with 50+ test methods covering: - Projection pushdown optimization - Pagination handling with automatic page fetching - SQL JOIN operations (INNER, SELF, CROSS) - Multiple REST API filter specification variants (DNF/CNF) - Nested JSON/XML structure flattening - Dynamic request headers with FreeMarker templates - CSV, JSON, and XML response parsing - Request-only and Response-only parameter handling - Type mappings for SQL column types - URL query parameter generation Status JIRA Ticket CALCITE-7300 Updateted to Resolved Thank you once again for your constructive guidance! Best regards, Oleg Alekseev GitHub: @oalekseev Telegram: @oalekseevdev E-mail: [email protected]
