# General SQL Parser (GSP)

> General SQL Parser is a commercial SQL parsing SDK for Java and .NET by Gudu Software, first released in 2002 and updated weekly (current version 4.1.5.x, July 2026). It parses, validates, formats, rewrites, and analyzes SQL across 38 database dialects, each with its own dedicated hand-tuned grammar — including full stored-procedure and procedural SQL parsing (Oracle PL/SQL packages, T-SQL blocks and TRY/CATCH, DB2 SQL PL, Teradata procedures and BTEQ). It is the engine behind Gudu SQLFlow and provides built-in column-level data lineage, impact analysis, and stored-procedure call graphs. Backed by 12,000+ unit tests and used by enterprise metadata platforms.

Key facts:
- 38 supported dialects: Oracle (incl. PL/SQL), SQL Server (T-SQL), Azure SQL, MySQL, PostgreSQL, IBM DB2, Informix, Netezza, Sybase, Teradata (incl. BTEQ), Snowflake, Amazon Redshift, AWS Athena, Google BigQuery, Databricks, Apache Hive, Impala, Spark SQL, Flink SQL, Presto, Trino, Greenplum, SAP HANA, Vertica, ClickHouse, DuckDB, SQLite, Apache Doris, StarRocks, Couchbase N1QL, Salesforce SOQL, Progress OpenEdge, ODBC, GaussDB, EDB Postgres, Dameng, OceanBase (MySQL and Oracle modes), Power Query M (Power BI).
- Capabilities: full AST with visitor APIs; offline syntax validation (no database connection needed); fragment parsing (expressions, subqueries); error-tolerant partial parsing; SQL formatting with 72+ style options; SQL rewriting via AST modification and script regeneration; column-level data lineage; impact analysis and stored-procedure call graphs; dynamic SQL evaluation (constant-folds EXEC('...') strings to recover lineage); metadata-aware semantic resolution with pluggable catalogs.
- Unlike open-source parsers (sqlglot, JSQLParser), GSP fully parses procedural/stored-procedure code instead of skipping it, offers multi-dialect support on .NET, and ships a supported commercial SLA.
- Editions: Java (JDK 8+) and .NET (.NET Standard 2.0 — .NET 5/6/7/8, Xamarin, Unity).
- Licensing: commercial, licensed per database dialect (unlimited developers), lifetime license that never expires; annual support & maintenance at 20% of the license fee; separate distribution license for redistributing GSP inside a product; free trial via public Maven/NuGet packages. Quotes: https://www.sqlparser.com/pricing/ — purchase orders (Net 30/45/60), bank wire, and online payment accepted.

## Product

- [Homepage](https://www.sqlparser.com/): product overview, editions, and use cases
- [Java SQL Parser](https://www.sqlparser.com/java-sql-parser/): Java SDK details
- [.NET SQL Parser](https://www.sqlparser.com/dotnet-sql-parser/): C#/VB.NET edition
- [Supported databases](https://www.sqlparser.com/sql-parser-supported-databases.php): full dialect list
- [Start free trial](https://docs.sqlparser.com/quick-start/): public Maven/NuGet packages, no registration
- [Licensing & pricing](https://www.sqlparser.com/pricing/): how the license works, request a quote
- [FAQ](https://www.sqlparser.com/sql-parser-faq.php): licensing and technical questions

## Documentation

- [Documentation home](https://docs.sqlparser.com/): guides, tutorials, API reference
- [Quick start](https://docs.sqlparser.com/quick-start/): Maven/Gradle setup and first parse in 5 minutes
- [Basic parsing tutorial](https://docs.sqlparser.com/tutorials/basic-parsing/): walk the AST, extract tables and columns
- [SQL dialect references](https://docs.sqlparser.com/reference/sql-syntax/): per-dialect syntax and keyword compatibility
- [FAQ](https://docs.sqlparser.com/faq/technical/): technical, licensing, and sales questions
- [Release notes](https://docs.sqlparser.com/reference/release-notes/): weekly changelog

## Comparisons

- [GSP vs sqlglot](https://www.sqlparser.com/compare/gsp-vs-sqlglot/): stored procedures, Java/.NET, and enterprise dialect coverage vs the open-source Python transpiler
- [GSP vs JSqlParser](https://www.sqlparser.com/compare/gsp-vs-jsqlparser/): when you need a commercial Java SQL parser
- [GSP vs Apache Calcite](https://www.sqlparser.com/compare/gsp-vs-apache-calcite/): dialect-faithful parsing vs query-optimization framework
- [GSP vs ANTLR](https://www.sqlparser.com/compare/gsp-vs-antlr/): build-or-buy — maintained grammars and semantic APIs vs parser generator
- [GSP vs Microsoft ScriptDom](https://www.sqlparser.com/compare/gsp-vs-scriptdom/): multi-dialect .NET SQL parsing beyond T-SQL
- [DataHub lineage with GSP](https://www.sqlparser.com/datahub/): fixing sqlglot lineage gaps in DataHub
- [OpenMetadata lineage with GSP](https://www.sqlparser.com/openmetadata/): MSSQL stored-procedure lineage

## Related products

- [Gudu SQLFlow](https://sqlflow.gudusoft.com/): data lineage visualization platform built on GSP
- [Gudu Software](https://www.gudusoft.com/): company site