SQL Parsing Tools for Vertica

General SQL Parser

https://www.sqlparser.com/

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:
Query analysis:
Query optimalization:
Syntax validation:

Go to vendor website

Queryparser

https://github.com/uber/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:
Query analysis:
Query optimalization:
Syntax validation:

Go to vendor website

SQL Parsing Tools for Vertica

General SQL Parser

Queryparser

Categories

Databases