3 SQL Parsing Tools / SQL Parsers for IBM DB2

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

JSQLParser

https://jsqlparser.github.io/JSqlParser/

JSQLParser is an RDBMS agnostic SQL statement parser. Built from JavaCC, it translates SQL statements into a traversable hierarchy of Java classes. It provides support for many dialects, such as Oracle, MS SQL Server, MySQL, MariaDB, PostgreSQL, H2, etc.

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

Go to vendor website

Active Query Builder

https://www.activequerybuilder.com/product.html

Active Query Builder is a full-featured component suite for software developers. It includes an SQL Query Parser to build an SQL query object model of any given SQL query and a Visual Query Builder component to design SQL queries via an intuitive visual interface. Moreover, it includes an SQL Text Editor with code completion and syntax highlighting, along with a highly-customizable SQL Query Text Formatter. In short, it gives end users a clear view of their queries and database schema.

Export:	Plain text,XML
Free edition:
Query analysis:
Query optimalization:
Syntax validation:

Go to vendor website

SQL Parsing Tools for IBM DB2

General SQL Parser

JSQLParser

Active Query Builder

Categories

Databases