A Sybase ASE 12.x SQL Parser & Object Model

About

A Java 1.5 library for parsing Sybase ASE 12.x T-SQL queries and stored procedures into an object model.

Features

• Free & open source (available under the LGPL licence)
• Parses a 'popular subset' of Sybase ASE 12.x T-SQL syntax
• Provides an extensive Java object model to inspect, analyse and manipluate Sybase syntax
• Object model is intuitive and easy to use (hand crafted, not auto generated from BNF)
• Provides a text renderer and an XML renderer (not yet available)
• Supports stored procedures as well as standalone SQL queries
• Pure Java (1.5) library (available as a jar) with no dependancies on external libraries
• Small library (~200KB), 97 classes, ~11,000 TLOC

Status

This project is currently in alpha status, meaning it is not yet feature complete and is not yet stable enough for use in a production environment. The parser and model are both fairly complete and should be able to cope with most queries and stored procedures. It has been validated against a set of over 1000 real stored procedures.

Version

The latest version available is 0.5.1.121 (alpha) which can be downloaded from this site.

Javadoc

The javadoc for the current release can be found at http://www.fairbait.com/sybaseparser_0.5.0.115_alpha/javadoc/