Skip to content

Use Cases & Demos

Real-world scenarios where General SQL Parser .NET is used in production.

Common use cases

  • SQL migration tooling — translate SQL between dialects (Oracle -> PostgreSQL, MSSQL -> Snowflake)
  • Code analysis and quality checking — SQL linters, style checkers, security scanners
  • SQL formatting and beautification — consistent style enforcement in CI
  • Automated SQL transformation — table/column renames, column removals, condition rewrites
  • Data lineage and impact analysis — column-level lineage across complex ETL pipelines
  • Schema documentation — extract tables, columns, constraints from DDL scripts
  • Query optimisation — programmatic transformations of the AST before execution
  • SQL validation in multi-vendor environments — pre-flight checks before sending queries to the right backend

Worked examples in the repo

The gsp_demo_dotnet/src/demos/ tree contains ~18 runnable C# console apps demonstrating these patterns. See the Demos page for the full list.

The three most load-bearing demos:

  • formatsql — the pretty-printer reference implementation
  • dataFlowAnalyzer — column-level lineage analysis (the engine behind SQLFlow)
  • extractTableColumns — the canonical AST-walking example

Hosted interactive demos

These are the same engines used inside Gudu's SQLFlow service.

See also