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.
TargetSQLConverter
ModoLegacy query refactor
ligações3 ligações
Outputs observáveis4 Outputs observáveis
Esta vista mostra o detalhe operacional do caso de uso com dados mock, logs e outputs observáveis. A versão real corre através de backends LAN ou do gateway Objlab.
Modo
A demo usa dados sintéticos e não chama diretamente a VM na LAN.
Métricas mock
- Queries converted: 94 - Guided conversions in the lab
- Tables mapped: 31 - Normalized and reusable relationships
- Legacy risks: 6 - Patterns to review before release
Software envolvido
- SQL transformer
- Schema mapper
- Diff viewer
Backend e orquestração
- www.objlab.it gateway
- SQLConverter API
- review log
Fluxo da demo
- Paste the query
- Choose the target
- See the conversion
- Compare output and differences
Mock request
{ "source": "legacy_sql", "dialect": "oracle", "target": "postgres", "mode": "conversion" }Mock response
{ "status": "ok", "converted": true, "tables": 31, "warnings": ["ROWNUM -> LIMIT", "CONNECT BY -> CTE"] }Outputs observáveis
Modernized queryDiffTable mappingMigration notes
Log de execução
Query rewritten to modern syntax
2 conversions require manual verification