TASK-P4-005: Refactor SQL Engine to Use Pipeline #3018

Task Details

Epic: #2978 (Phase 4: Query & Quality)
Priority: CRITICAL
Effort: 7 days
Dependencies: TASK-P4-004

Description

Migrate SQL query engine to unified pipeline architecture.

Steps

1. Create SQLQueryLanguageAdapter
2. Implement SQL → LogicalPlan translation
3. Update SQL parser to build logical plan
4. Remove old SQL execution code (gradually)
5. Add comprehensive SQL tests
6. Performance validation
7. Ensure backward compatibility

Files to Modify

• query-sql/src/main/java/com/arcadedb/query/sql/SQLQueryEngine.java
• query-sql/src/main/java/com/arcadedb/query/sql/parser/**

Files to Create

• query-sql/src/main/java/com/arcadedb/query/sql/SQLAdapter.java
• query-sql/src/main/java/com/arcadedb/query/sql/translator/SQLToLogicalPlan.java

Acceptance Criteria

• SQL uses new pipeline
• All SQL tests pass
• No performance regression
• Backward compatible