General SQL Parser Overview

We collect all kinds of examples on this page to illustrate how to use general sql parser, helping 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.

• Benchmark of General SQL Parser
• Add SQL format/beautify feature in your own program in 5 minutes, 10 lines code with more than 80 format options.
• User customized color of formatted SQL element in RTF and HTML.
• Vendor-specific offline syntax check.
  
• Fetch columns and tables in SQL script.
  
• Find out what clause a DB Object belongs to?(Java version).
  
• Get referenced table and columns in select list item (Java version).
  
• Separate the SQL Commands in SQL script.
  
• SQL modify and rebuild, SQL refactor.
  • Deconstruct, Modify, Rebuild an SQL statement(Java version)
    
  • Deconstruct, Modify, Rebuild an SQL statement(Java version, part 2, use low level APIs)
    
  • Add, remove and modify condition in where clause(.NET version)
    
  • Remove SQL/user defined variables in where clause without broken condition expression.
    
  • Build various SQL elements from scratch.
    
  • Analyze 2 select statements, then merge into one statement.
    
  • Replace constant in query with SQL variables.
    
  • Rename table names in SQL script.
    
  • Rewrite Oracle proprietary joins to ANSI SQL compliant joins.
    
  • Rewrite SQL Server proprietary joins to ANSI SQL compliant joins.
    
  • Oracle SQL Query rewrite
  • Remove duplicated parenthesis in SQL statement
• Generate internal query parse tree in xml output for further processing.
  
• In-depth analysis of SQL script.
  • Decoding/Analyze SQL grammar
    • Select SQL Statement
    • Get columns in select list
    • Insert SQL Statement
    • Update SQL Statement
    • Delete SQL Statement
    • Create/Alter Table SQL Statement
    • Oracle PLSQL Procedure
    • Create view Statement
  • Visit SQL statement recursively.
  • Parsing affected db objects (.NET version)
  • Parsing affected db objects (Java version)
  • 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
  • Parse the values and field names in where clause
  • Column impact analysis
  • How to get table/column relation by analyzing sql join condition
  • 
    Table and column relations in SQL script files
    
  • 
    SQL Server stored procedure analysis tool
    
  • 
    Scan SQL stored procedures/udfs/views, return the table name with columns
    
• Translate SQL query between different databases.
• SQL Injection Tool
• Sorting Views Script by Dependency
• Get all the variables in an Oracle Package, Procedure or Function

All these demos shipped together with general sql parser library.