Browsable SQLDML 1.0 Grammar

Grammar extracted by Vadim Zaytsev, see the Grammar Zoo entry for details: §wip/atl/SQLDML/extracted
Source used for this grammar: Marcos Didonet Del Fabro, SQLDML 1.0, SQLDML.ecore, 2006/08/28

Summary

• Total 51 production rules with 52 top alternatives and 222 symbols.
• Vocabulary: 54 = 31 nonterminals + 2 terminals + 21 labels + 0 markers.
• Total 31 nonterminal symbols: 31 defined (Boolean, Integer, String, LocatedElement, SQLRoot, Statement, ViewStatement, InsertStmt, QueryStmt, QueryStmtCol, QueryStmtAllCol, NamedElement, Table, WhereClause, Expression, BinaryExp, OrExp, AndExp, NotExp, LikeExp, InExp, OperationExp, Predicate, QueryPredicate, ColumnExp, ValueExp, StringValueExp, IntegerValueExp, ListExp, FunctionExp, DataType), 0 root (—), 2 top (Boolean, LocatedElement), 0 bottom (—).
• Total 2 terminal symbols: 2 keywords ("true", "false"), 0 letters (—), 0 numerics (—), 0 signs (—).
• Total 21 labels: [statements], [name] ³, [columns] ², [query] ², [tableName], [values], [tables], [condition], [alias] ², [expression] ², [opName] ³, [leftExp] ², [rightExp] ², [valueExp], [unused], [columnName] ², [elements] ², [optName], [type], [aValue] ², [arguments].

Syntax

Boolean ::=
	"true"
	"false"

Integer ::=
	integer

String ::=
	string

LocatedElement ::=
	SQLRoot

LocatedElement ::=
	Statement

LocatedElement ::=
	NamedElement

LocatedElement ::=
	WhereClause

LocatedElement ::=
	Expression

SQLRoot ::=
	[statements]::Statement+

Statement ::=
	ViewStatement

Statement ::=
	InsertStmt

Statement ::=
	QueryStmt

ViewStatement ::=
	[name]::String [columns]::ColumnExp+ [query]::QueryStmt

InsertStmt ::=
	[tableName]::String [values]::Expression+

QueryStmt ::=
	QueryStmtCol

QueryStmt ::=
	QueryStmtAllCol

QueryStmtCol ::=
	[columns]::Expression+

QueryStmtAllCol ::=
	[tables]::Table+ [condition]::WhereClause

NamedElement ::=
	Table

NamedElement ::=
	DataType

NamedElement ::=
	ColumnExp

Table ::=
	[alias]::String

WhereClause ::=
	[expression]::Expression

Expression ::=
	BinaryExp

Expression ::=
	NotExp

Expression ::=
	LikeExp

Expression ::=
	InExp

Expression ::=
	Predicate

Expression ::=
	QueryPredicate

BinaryExp ::=
	OrExp

BinaryExp ::=
	AndExp

BinaryExp ::=
	OperationExp

OrExp ::=
	[opName]::String [leftExp]::Expression [rightExp]::Expression

AndExp ::=
	[opName]::String [leftExp]::Expression [rightExp]::Expression

NotExp ::=
	[opName]::String [valueExp]::Expression [unused]::Expression

LikeExp ::=
	[columnName]::String [expression]::StringValueExp

InExp ::=
	[columnName]::String [elements]::Predicate+

OperationExp ::=
	[optName]::String

Predicate ::=
	ValueExp

Predicate ::=
	ListExp

Predicate ::=
	FunctionExp

Predicate ::=
	ColumnExp

QueryPredicate ::=
	[query]::QueryStmt

ColumnExp ::=
	[alias]::String [type]::DataType

ValueExp ::=
	StringValueExp

ValueExp ::=
	IntegerValueExp

StringValueExp ::=
	[aValue]::String

IntegerValueExp ::=
	[aValue]::Integer

ListExp ::=
	[elements]::Expression+

FunctionExp ::=
	[arguments]::Expression+ [name]::String

DataType ::=
	[name]::String

Maintained by Dr. Vadim Zaytsev a.k.a. @grammarware. Last updated in September 2015. [↑]