sqlparser.com

General SQL Parser Overview

Hi, Thank you for coming to visit our website, hope you can find what you need here. General SQL Parser can adds powerful sql processing capability to your program, it CAN help you in the following ways:

• Add SQL format/beautify feature in your own program in 5 minutes, 10 lines code with more than 60 format options.
• Vendor-specific offline syntax check.
  
• Fetch columns and tables in SQL script.
  
• Separate the SQL Commands in SQL script.
  
• SQL modify and rebuild, SQL refactor.
  • Build various SQL elements from scratch.
    
  • Analyze 2 select statements, then merge into one statement.
    
  • Remove SQL variables in where clause without broken condition expression.
    
  • Replace constant in query with SQL variables.
    
  • Rename table names in SQL script.
    
  • Rewrite Oracle propriety joins to ANSI SQL compliant joins.
    
  • Rewrite SQL Server propriety joins to ANSI SQL compliant joins.
    
• Generate internal query parse tree in xml output for further processing.
  
• In-depth analysis of SQL script.
  • Visit SQL statement recursively.
  • Find all variables in SQL script.
    
  • Find duplicated variables in SQL Server script.
    
  • SQL expression parse tree traversal in preorder/inorder/postorder.
    
  • Analyze DDL statement
  • CRUD Reportor
• Translate SQL query between different databases.

All these demos shipped together with general sql parser library.

It seems that General SQL Parser is exactly what I’m looking for, but I can’t find demo that meet my requirement?
Should you need any further assistance, don’t hesitate to contact us.

• Home Page
• Demos
• Request a demo

Resources

• Docs
• SQL Pretty Printer