Legacy query with joins and nested subqueries received
SQLConverter
A scenario for converting legacy SQL, mapping tables, and refactoring complex queries with a guided view.
目标SQLConverter
模式Legacy query refactor
连接3 连接
可观测输出4 可观测输出
此视图以 mock 数据、日志和可观测输出展示用例的操作细节。正式版本通过 LAN 后端或 Objlab gateway 运行。
模式
该演示使用合成数据，不直接调用 LAN 虚拟机。
Mock 指标
- Queries converted: 94 - Guided conversions in the lab
- Tables mapped: 31 - Normalized and reusable relationships
- Legacy risks: 6 - Patterns to review before release
涉及的软件
- SQL transformer
- Schema mapper
- Diff viewer
后端与编排
- www.objlab.it gateway
- SQLConverter API
- review log
演示流程
- Paste the query
- Choose the target
- See the conversion
- Compare output and differences
Mock 请求
{ "source": "legacy_sql", "dialect": "oracle", "target": "postgres", "mode": "conversion" }Mock 响应
{ "status": "ok", "converted": true, "tables": 31, "warnings": ["ROWNUM -> LIMIT", "CONNECT BY -> CTE"] }可观测输出
Modernized queryDiffTable mappingMigration notes
执行日志
Query rewritten to modern syntax
2 conversions require manual verification