sqlparser.com

List of demos illustrate how to use general sql parser

We collect all kinds of examples in this page to illustrate how to use general sql parser, help you to make better use of this library. Some of those examples were requested by our customers, we publish those examples here too. If you need any examples that can’t find here, feel free to contact us to request a demo.

• 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.

• Home Page
• Demos
• Request a demo

Resources

• Docs
• SQL Pretty Printer