SQL::Lexer

** Under Construction - Pull requests welcome **

Description

This grammer is a foundation for SQL Language parsers. It handles the common lexical constructs of SQL.

Primary Tokens

Special Characters

• singlequote
• doublequote
• quote - either single or double
• backquote
• period
• underscore
• plus-sign
• minus-sign
• left-paren
• right-paren
• colon
• semicolon
• comma
• solidus - ordinary forward slash

Comments

• simple-comment - '--' or '#' to end-of-line
• bracketed-comment - '/*' to '*/' multi-line comment
• comment - either of the above

Literals

• literal
• signed-numeric-literal
• unsigned-numeric-literal
• char-sting-literal
• datetime-literal
• interval-literal
• date-string
• time-string
• timestamp-string
• boolean-literal

Operators

• operator-symbol
• equals-operator
• non-equals-operator
• less-than-operator
• greater-than-operator
• plus-operator
• minus-operator
• multiply-operator
• divide-operator
• greater-than-or-equals-operator
• less-than-or-equals-operator

Identifiers

• quoted-label quoted with backtick
• regular-identifier
• keyword
• non-reserved-word
• reserved-word

=== Other ===

• variable