SQL dialect
SQLite SQL Parser for Java and .NET
General SQL Parser (GSP) parses SQLite with a dedicated, hand-tuned grammar — full AST access, offline syntax validation, formatting, rewriting, and column-level data lineage . One commercial SDK, 38 dialects, Java and .NET.
Example
SQLite SQL that GSP parses
ATTACH DATABASE 'archive.db' AS archive;
PRAGMA foreign_keys = ON;
CREATE VIRTUAL TABLE docs USING fts5(title, body);Parse it in Java
import gudusoft.gsqlparser.*;
TGSqlParser parser = new TGSqlParser(EDbVendor.dbvsqlite);
parser.sqltext = sql; // the SQLite SQL above
if (parser.parse() == 0) {
System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
System.out.println(parser.getErrormessage());
}The .NET edition exposes the same API in C# — see the C# quick start.
Coverage
What GSP handles in SQLite
- ATTACH/DETACH DATABASE
- PRAGMA statements
- CREATE VIRTUAL TABLE (FTS5)
Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for SQLite.
Go deeper
SQLite resources
- SQLite syntax reference — dialect documentation
- SQLite keyword compatibility — every keyword, and whether it can be an identifier
- Java quick start — Maven/Gradle setup and first parse
- C# quick start — NuGet setup for .NET
Common questions
Do I need a SQLite database connection to validate SQL?
No. GSP validates SQLite syntax completely offline. You get error line and column positions, the offending token, and a hint — with no server, driver, or credentials involved.
How complete is the SQLite grammar?
GSP uses a dedicated hand-tuned grammar for SQLite — not a generic SQL grammar with flags. The parser recognizes 567 SQLite keywords and knows which 495 of them can also be used as identifiers, which is exactly the kind of edge case that breaks generic parsers.
Can I use the SQLite parser from C# / .NET?
Yes. The .NET edition (NuGet package gudusoft.gsqlparser, .NET Standard 2.0) exposes the same API surface as the Java edition, so every SQLite parsing feature on this page works in C# and VB.NET.
Can GSP extract column-level lineage from SQLite SQL?
Yes. The built-in DataFlowAnalyzer produces column-level lineage, impact analysis, and call graphs from SQLite scripts — it is the engine behind Gudu SQLFlow and the lineage integrations for DataHub and OpenMetadata.