Documents

Welcome to our new documentation website for General SQL Parser! We've created comprehensive documentation to help you get the most out of our SQL parsing tools and APIs. The new docs include detailed guides, tutorials, API references, and examples. Please visit docs.sqlparser.com to access the latest documentation.

The old documents are still available on this page for reference.

• .NET VERSION release note
• Java VERSION release note
• VCL VERSION release note
• General SQL Parser Java version Developer's Guide(pdf, 419K)
• Important notice when using GSP with Java 9 and higher version
• Download GSP Javadoc (zip, 13.6M)
• Install and use the Genearl SQL Parser package using the dotnet CLI
• General SQL Parser User Guide(pdf, 484K)
• Benchmark
• Introduction about how general sql parser works
• Supported SQL dialect of various databases
• How join table was organized in query parse tree
• How expression/condition in where clause was organized
• Decoding SQL Grammar
• SQL XML Schema
• Samples of SQL query tree in XML
• Retrieve/Refactor table & column name
• Column impact analysis
• Determining Impact and Data Lineage
• 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
• Oracle SQL Query rewrite
• Scan SQL stored procedures/udfs/views, return the table name with columns
• Modern PL/SQL Code Checking and Dependency Analysis
• A FILTER-BASED APPROACH FOR SQL INJECTION ATTACK DETECTION
• A General SQL-Rewriting Engine - ECSL - Stony Brook

Features:

• table column affected

• rename table column