chrislu
|
24394af58b
|
remove order by, group by, join
|
13 hours ago |
chrislu
|
f15fc6b7f0
|
clean up
|
2 days ago |
chrislu
|
b1054bf43a
|
Update SQL_FEATURE_PLAN.md
|
2 days ago |
chrislu
|
2d582f9cb6
|
Update SQL_FEATURE_PLAN.md
|
2 days ago |
chrislu
|
92a1ab25f4
|
address comments
|
2 days ago |
chrislu
|
04e83281f2
|
Update SQL_FEATURE_PLAN.md
|
2 days ago |
chrislu
|
164158b2a1
|
Update SQL_FEATURE_PLAN.md
|
3 days ago |
chrislu
|
e030913d9f
|
clean up
|
3 days ago |
Chris Lu
|
623a278a0f
|
Update SQL_FEATURE_PLAN.md
Co-authored-by: gemini-code-assist[bot] <176961590+gemini-code-assist[bot]@users.noreply.github.com>
|
3 days ago |
chrislu
|
d192536376
|
fix
|
3 days ago |
chrislu
|
bdce5439d8
|
fixes
|
3 days ago |
chrislu
|
4060ea34a9
|
Update SQL_FEATURE_PLAN.md
|
3 days ago |
chrislu
|
e3e369c264
|
change to pg_query_go
|
4 days ago |
chrislu
|
59d6806146
|
fix empty spaces and coercion
|
4 days ago |
chrislu
|
ad86637e0b
|
feat: Phase 1 - Add SQL query engine foundation for MQ topics
Implements core SQL infrastructure with metadata operations:
New Components:
- SQL parser integration using github.com/xwb1989/sqlparser
- Query engine framework in weed/query/engine/
- Schema catalog mapping MQ topics to SQL tables
- Interactive SQL CLI command 'weed sql'
Supported Operations:
- SHOW DATABASES (lists MQ namespaces)
- SHOW TABLES (lists MQ topics)
- SQL statement parsing and routing
- Error handling and result formatting
Key Design Decisions:
- MQ namespaces ↔ SQL databases
- MQ topics ↔ SQL tables
- Parquet message storage ready for querying
- Backward-compatible schema evolution support
Testing:
- Unit tests for core engine functionality
- Command integration tests
- Parse error handling validation
Assumptions (documented in code):
- All MQ messages stored in Parquet format
- Schema evolution maintains backward compatibility
- MySQL-compatible SQL syntax via sqlparser
- Single-threaded usage per SQL session
Next Phase: DDL operations (CREATE/ALTER/DROP TABLE)
|
6 days ago |