Couchbase N1QL SQL Parser for Java and .NET

Example

Couchbase N1QL SQL that GSP parses

UPSERT INTO product (KEY, VALUE)
VALUES ("odwalla-juice1",
  {"productId": "odwalla-juice1", "unitPrice": 5.40})
RETURNING *;

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvcouchbase);
parser.sqltext = sql; // the Couchbase N1QL 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 Couchbase N1QL

• UPSERT with KEY/VALUE
• Nested JSON literals
• INFER keyspace
• BUILD INDEXES
• ANSI JOIN ... ON

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for Couchbase N1QL.

Actively maintained

Recent Couchbase N1QL parser updates

• 2026-06-02 [Couchbase] Parse ANSI JOIN ... ON <predicate>
• 2026-01-11 Delegate BigQuery, Athena, and Couchbase parsing to VendorParsers
• 2025-10-07 Migrate Couchbase to modular architecture

Full history in the release notes.