gudusoft.gsqlparser.parser

Class BigQuerySqlParser

Object

gudusoft.gsqlparser.parser.AbstractSqlParser

gudusoft.gsqlparser.parser.BigQuerySqlParser

All Implemented Interfaces:

SqlParser

public class BigQuerySqlParser
extends AbstractSqlParser

Google BigQuery SQL parser implementation.

This parser handles BigQuery-specific SQL syntax including:

• BigQuery scripting language (BEGIN...END blocks, IF/WHILE/FOR/LOOP/REPEAT statements)
• BigQuery UDFs (CREATE FUNCTION with SQL or JavaScript)
• BigQuery procedures (CREATE PROCEDURE with BEGIN...END blocks)
• Special type handling (STRUCT, ARRAY, DATE/TIME/TIMESTAMP literals)
• Backtick-quoted identifiers including qualified names (`schema.table`)
• BigQuery-specific keywords and functions

Design Notes:

• Extends AbstractSqlParser using the template method pattern
• Uses TLexerBigquery for tokenization
• Uses TParserBigquery for parsing
• Delimiter character: ';' for SQL statements
• Splits backtick-quoted qualified names (`schema.table`) into individual tokens

Usage Example:

 // Get BigQuery parser from factory
 SqlParser parser = SqlParserFactory.get(EDbVendor.dbvbigquery);

 // Build context
 ParserContext context = new ParserContext.Builder(EDbVendor.dbvbigquery)
     .sqlText("SELECT * FROM `project.dataset.table` WHERE region = 'US'")
     .build();

 // Parse
 SqlParseResult result = parser.parse(context);

 // Access statements
 TStatementList statements = result.getSqlStatements();
 

Since:

3.2.0.0

See Also:

SqlParser, AbstractSqlParser, TLexerBigquery, TParserBigquery

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.parser.AbstractSqlParser

AbstractSqlParser.PreparedSqlReader

Field Summary

Fields

Modifier and Type	Field and Description
TLexerBigquery	flexer The BigQuery lexer used for tokenization

Fields inherited from class gudusoft.gsqlparser.parser.AbstractSqlParser

defaultDelimiterStr, delimiterChar, frameStack, globalContext, globalFrame, lexer, sourcetokenlist, sqlcmds, sqlEnv, sqlstatements, syntaxErrors, vendor

Constructor Summary

Constructors

Constructor and Description
BigQuerySqlParser() Construct BigQuery SQL parser.

Method Summary

Modifier and Type	Method and Description
protected void	afterStatementParsed(TCustomSqlStatement stmt) Post-process statement after parsing (hook method).
protected void	extractVendorRawStatements(SqlParseResult.Builder builder) Call BigQuery-specific raw statement extraction logic.
protected TCustomLexer	getLexer(ParserContext context) Return the BigQuery lexer instance.
protected TCustomParser	getParser(ParserContext context, TSourceTokenList tokens) Return the BigQuery SQL parser instance with updated token list.
protected TCustomParser	getSecondaryParser(ParserContext context, TSourceTokenList tokens) BigQuery does not use a secondary parser (unlike Oracle with PL/SQL).
protected void	performInterpreter(ParserContext context, TStatementList statements) Perform interpretation/evaluation on statements.
protected TStatementList	performParsing(ParserContext context, TCustomParser parser, TCustomParser secondaryParser, TSourceTokenList tokens, TStatementList rawStatements) Parse all SQL statements after tokenization and raw extraction.
protected void	performSemanticAnalysis(ParserContext context, TStatementList statements) Perform semantic analysis on parsed statements.
protected void	setupVendorParsersForExtraction() Setup BigQuery parser for raw statement extraction.
protected void	tokenizeVendorSql() Call BigQuery-specific tokenization logic.
String	toString()

Methods inherited from class gudusoft.gsqlparser.parser.AbstractSqlParser

attemptErrorRecovery, copyErrorsFromStatement, doAfterTokenize, doExtractRawStatements, extractRawStatements, getanewsourcetoken, getDefaultDelimiterStr, getDelimiterChar, getErrorCount, getrawsqlstatements, getSyntaxErrors, getVendor, handleStatementParsingException, initializeGlobalContext, isDollarFunctionDelimiter, onRawStatementComplete, onRawStatementCompleteVendorSpecific, parse, performTokenization, prepareSqlReader, processTokensBeforeParse, processTokensInTokenTable, setTokenHandle, tokenize, towinlinebreak

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

flexer

public TLexerBigquery flexer

The BigQuery lexer used for tokenization

Constructor Detail

BigQuerySqlParser

public BigQuerySqlParser()

Construct BigQuery SQL parser.

Configures the parser for BigQuery database with default delimiter (;).

Following the original TGSqlParser pattern, the lexer and parser are created once in the constructor and reused for all parsing operations.

Method Detail

getLexer

protected TCustomLexer getLexer(ParserContext context)

Return the BigQuery lexer instance.

Specified by:

getLexer in class AbstractSqlParser

Parameters:

context - the parser context

Returns:

configured lexer instance (never null)

getParser

protected TCustomParser getParser(ParserContext context,
                                  TSourceTokenList tokens)

Return the BigQuery SQL parser instance with updated token list.

Specified by:

getParser in class AbstractSqlParser

Parameters:

context - the parser context

tokens - the source token list

Returns:

configured parser instance (never null)

getSecondaryParser

protected TCustomParser getSecondaryParser(ParserContext context,
                                           TSourceTokenList tokens)

BigQuery does not use a secondary parser (unlike Oracle with PL/SQL).

Overrides:

getSecondaryParser in class AbstractSqlParser

Parameters:

context - the parser context

tokens - the source token list

Returns:

secondary parser instance, or null if not needed

tokenizeVendorSql

protected void tokenizeVendorSql()

Call BigQuery-specific tokenization logic.

Delegates to dobigquerysqltexttotokenlist which handles BigQuery's specific keyword recognition, backtick-quoted identifiers, and qualified name splitting.

Specified by:

tokenizeVendorSql in class AbstractSqlParser

setupVendorParsersForExtraction

protected void setupVendorParsersForExtraction()

Setup BigQuery parser for raw statement extraction.

BigQuery uses a single parser, so we inject sqlcmds and update the token list for the main parser only.

Specified by:

setupVendorParsersForExtraction in class AbstractSqlParser

extractVendorRawStatements

protected void extractVendorRawStatements(SqlParseResult.Builder builder)

Call BigQuery-specific raw statement extraction logic.

Delegates to dobigquerygetrawsqlstatements which handles BigQuery's statement delimiters and scripting language boundaries (BEGIN...END blocks, IF/WHILE/FOR/LOOP statements).

Specified by:

extractVendorRawStatements in class AbstractSqlParser

Parameters:

builder - the result builder to populate with raw statements

performParsing

protected TStatementList performParsing(ParserContext context,
                                        TCustomParser parser,
                                        TCustomParser secondaryParser,
                                        TSourceTokenList tokens,
                                        TStatementList rawStatements)

Parse all SQL statements after tokenization and raw extraction.

This method iterates through all statements, calls parsestatement on each, and handles error recovery for CREATE TABLE statements if enabled.

Inherited performParsing pattern from AbstractSqlParser, specialized for BigQuery.

Specified by:

performParsing in class AbstractSqlParser

Parameters:

context - the parser context

parser - the main parser instance

secondaryParser - secondary parser (may be null)

tokens - the source token list

rawStatements - raw statements already extracted (never null)

Returns:

statement list with parsed AST (never null)

afterStatementParsed

protected void afterStatementParsed(TCustomSqlStatement stmt)

Post-process statement after parsing (hook method).

BigQuery does not require special post-processing, so this is a no-op. Override if BigQuery-specific validation is needed in the future.

Overrides:

afterStatementParsed in class AbstractSqlParser

Parameters:

stmt - the statement that was just parsed

performSemanticAnalysis

protected void performSemanticAnalysis(ParserContext context,
                                       TStatementList statements)

Perform semantic analysis on parsed statements.

Runs TSQLResolver to build relationships between tables and columns, resolve references, and perform type checking.

Overrides:

performSemanticAnalysis in class AbstractSqlParser

Parameters:

context - the parser context

statements - the parsed statements (mutable)

performInterpreter

protected void performInterpreter(ParserContext context,
                                  TStatementList statements)

Perform interpretation/evaluation on statements.

Runs TASTEvaluator to execute constant expressions and compile-time evaluations.

Overrides:

performInterpreter in class AbstractSqlParser

Parameters:

context - the parser context

statements - the parsed statements (mutable)

toString

public String toString()

Overrides:

toString in class AbstractSqlParser