node package manager


An SQL Lexer for JavaScript

Build Status

This is the start of an SQL lexer for JavaScript. When complete, it should be able to produce tokens suitable for parsing standard SQL92 and SQL2011. Support for intervening versions is dependent on availability of documentation.

Lexing is currently available for SQL92, MySQL and SQLite. Postgres is intended for addition soon.

See the examples directory for syntax highlighters and token dumpers.

This library is intended to be the basis for other tools:

  • Script executers that provide better diagnostics then dumping a .sql file into the commandline.
  • Parsers, which can then SQL level diffs / migration help (ala Modyllic), schema translation (ala SQL::Translator), and SQL quering of non-SQL backends (ala DBD::CSV)