Skip to content

General SQL Parser Documentation

Welcome to the comprehensive documentation for General SQL Parser (GSP) - a powerful Java library designed to parse, analyze, and evaluate SQL queries from more than 30 different database systems including Oracle, SQL Server, DB2, PostgreSQL, MySQL, and many more.

What is General SQL Parser?

General SQL Parser is a robust, enterprise-grade SQL parsing library that provides developers with the tools to:

  • Parse complex SQL statements from multiple database vendors
  • Analyze SQL syntax and structure with detailed AST (Abstract Syntax Tree) support
  • Evaluate and transform SQL queries programmatically
  • Validate SQL syntax across different database dialects
  • Extract metadata, dependencies, and lineage information

Key Features

🚀 Multi-Database Support

Support for 30+ database systems including Oracle, SQL Server, PostgreSQL, MySQL, DB2, Teradata, BigQuery, Snowflake, and more.

⚡ High Performance

Optimized parsing engine built for production environments with minimal memory footprint and fast processing.

🔧 Comprehensive API

Rich Java API with detailed documentation for all parsing, analysis, and transformation operations.

🎯 Production Ready

Battle-tested in enterprise environments with robust error handling and extensive test coverage.

📊 Advanced Analysis

Deep SQL analysis capabilities including dependency tracking, column lineage, and impact analysis.

Quick Start

Get up and running with General SQL Parser in minutes:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.EDbVendor;

// Initialize parser for Oracle SQL
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvoracle);

// Parse your SQL
sqlparser.sqltext = "SELECT * FROM employees WHERE salary > 50000";
int result = sqlparser.parse();

if (result == 0) {
    System.out.println("Parsing successful!");
    // Access the parsed SQL structure
} else {
    System.out.println("Parse error: " + sqlparser.getErrormessage());
}

Get Started →

Documentation Structure

This documentation follows the Diátaxis framework to provide you with the most effective learning experience:

Learning-oriented guides that teach you how to use General SQL Parser through practical, hands-on examples.

Problem-oriented solutions for specific tasks and real-world scenarios.

Information-oriented documentation including API references and comprehensive syntax guides.

Understanding-oriented content that explains the concepts and architecture behind General SQL Parser.

Use Cases

General SQL Parser is trusted by developers and organizations worldwide for:

  • Data Migration Tools - Parse and convert SQL between different database platforms
  • SQL Validation - Validate SQL syntax before execution in multi-database environments
  • Code Analysis - Analyze SQL code quality, dependencies, and impact
  • Query Optimization - Transform and optimize SQL queries programmatically
  • Database Documentation - Extract metadata and generate documentation from SQL code
  • ETL Tools - Parse and analyze SQL in data integration pipelines

Explore Use Cases →

Community & Support

  • 📖 FAQ - Find answers to common questions
  • 🛠️ Contributing - Help improve General SQL Parser
  • 💬 Support - Get help from the community and support team
  • 📧 Contact us for enterprise support and licensing

License

General SQL Parser is available under both commercial and trial licenses. See our licensing FAQ for more information.

Ready to start parsing SQL like a pro? Get Started Now →