JSQLParser/JSqlParser jsqlparser-0.8.8

on GitHub

Extensions Version 0.8.8

• Startet a simple utility class SelectUtils to collect basic select modification tools.
  • addExpression adds a new expression to the select list.
  • addJoin adds a new join to the select.
• Added support for optional " AS " for aliases.

SELECT * FROM mytable myalias

• Added first support for ALTER TABLE statements

ALTER TABLE mytable ADD COLUMN mycolumn varchar (255)

• Added support for PostgreSQL regular expression match operators.

SELECT a, b FROM foo WHERE a ~ '[help].*';
SELECT a, b FROM foo WHERE a ~* '[help].*';
SELECT a, b FROM foo WHERE a !~ '[help].*';
SELECT a, b FROM foo WHERE a !~* '[help].*';