SQL Parsing Tools for Vertica

General SQL Parser

General SQL Parser is a SQL Parser developed by Gudu Software that simplifies decoding SQL grammar and helps your applications stay current with the latest versions of database programs. It makes it easy to fetch, modify, and rewrite SQL segment and prepares a detailed SQL parse tree node structure. With General SQL Parser, you can clean up messy SQL codes, detect SQL Syntax errors, find affected SQL objects, rewrite and convert SQL, and do a lot more.

Export: HTML,Plain text,RTF
Free edition: No
Query analysis: Yes
Query optimalization: Yes
Syntax validation: Yes
parse2
parsingSQL1
parsingSQL3

Queryparser

Queryparser supports parsing and analysis for three SQL-dialects, i.e., Vertica, Hive, and Presto. Each dialect implements its own tokenization and parsing logic. There is a single abstract syntax tree (AST) for representing queries of any dialect. This AST is defined in Database/Sql/Type.hs and Database/Sql/Type/Query.hs. The parsing logic produces an AST with table and column identifiers that are "raw" or optionally qualified.

Export: -
Free edition: Yes
Query analysis: Yes
Query optimalization: No
Syntax validation: No