Objlab
Partner areaClient areaStaff area
← Back to scenarios
Level 2 - Scenario sheetSQL Conversion

SQLConverter

A scenario for converting legacy SQL, mapping tables, and refactoring complex queries with a guided view.

TargetSQLConverter
ModeLegacy query refactor
links3 links
Observable outputs4 Observable outputs
Gateway: www.objlab.it·Mock demo: active·Mode: Legacy query refactor
Request a guided demoView product demo
Level 3 - Operational demo

This view shows the operational detail of the use case with mock data, logs and observable outputs. The real version runs through LAN backends or the Objlab gateway.

Mode

The demo uses synthetic data and does not call the LAN VM directly.

Mock metrics

  • Queries converted: 94 - Guided conversions in the lab
  • Tables mapped: 31 - Normalized and reusable relationships
  • Legacy risks: 6 - Patterns to review before release

Software involved

  • SQL transformer
  • Schema mapper
  • Diff viewer

Backend and orchestration

  • www.objlab.it gateway
  • SQLConverter API
  • review log

Demo flow

  1. Paste the query
  2. Choose the target
  3. See the conversion
  4. 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"] }

Observable outputs

Modernized queryDiffTable mappingMigration notes

Execution log

Input

Legacy query with joins and nested subqueries received

Transform

Query rewritten to modern syntax

Review

2 conversions require manual verification