Functions in Select statement

Summary

The SQL statement builder now supports pre-defined Exasol functions and Exasol user-defined functions in a Select statement.

Example:

SELECT POWER(2,10) POWER;

SELECT my_average(x) FROM t;

Changes

• #57: added java primitive types literals
• #66: added pre-defined scalar functions to the select statement
• #69: updated documentation
• #70: added pre-defined aggregate and analytic functions to the select statement
• #74: added support for UDF to the select statement

Column references in value expressions

Summary

The SQL statement builder now supports column references in the value expressions.

Example:

MERGE INTO ...  VALUES ("SRC"."ID", ...)

Changes

• #56: Support column references in the value expressions

Unified `has...()` in `MERGE`

Summary

We unified the use of has...() and get...() methods that allow access to building blocks of a MERGE statement.
Also the project now has a logo.

Changes

• #54: Improved MERGE and its documentation

`WHERE` in `MERGE`

Changes

Breaking change: The columnReference(...) methods in ExpressionTerm where renamed to column(...) and the parameters reordered so that tables are in front of columns.

• #50: MERGE Statement now supports WHERE clause

`MERGE`, `ORDER BY` and `GROUP BY`

Summary

With this release the SQL Statement Builder supports MERGE (except for the WHERE clauses), ORDER BY and GROUP BY.

Breaking Changes

The Method getAs() in Table was renamed to getAlias() and now returns a String instead of an Optional<String>. To check for the existence without having to check for null, we added the method hasAlias().

Changes

• #46: Added ORDER BY and GROUP BY
• #50: Added MERGE

SQL Statement Builder 1.1.0

• #41: Implemented DROP TABLE SQL statement
• #43: Implemented CREATE SCHEMA SQL statement
• #43: Implemented DROP SCHEMA SQL statement
• Moved SELECT- and INSERT-related classes into appropriate packages named select and insert

SQL Statement Builder 0.4.1

• #12: Removed Travis CI run with Java 11 because of JavaDoc incompatibilities.
• #12: Added support for value tables. Adapted dependent code.
• #23: Added Sonar checks and badges.
• #27: Fixed Sonar findings.
• #29: Implemented 'CREATE TABLE'.
• #36: Wrote CREATE TABLE part of the users guide.

Initial statement builder

Features

• PMI-66: Initial statement builder
• PMI-86: LIMIT clause, Eclipse launch configurations and Travis CI build
• PMI-95: Auto-quoting
• PMI-97: Support for Exasol Intervals