Added BigDecimal literal

Features / Enhancements

• #87: Added BigDecimal literal

Ported to Java 11, bug fixes and new select features

Bug Fixes

• #78: Fixed the bug with BooleanExpression quotation.

Features / Enhancements

• #80: Added ossindex-maven-plugin and versions-maven-plugin, updated dependencies.
• #81: Ported from Java 8 to Java 11.
• #76: Added SELECT FROM VALUES ... AS support.
• #77: Added SELECT FROM (SELECT ...) support.

Refactoring

• #27: Fix sonar findings.

Dependency updates

Click to expand

• Added org.sonatype.ossindex.maven:ossindex-maven-plugin:3.1.0
• Added org.codehaus.mojo:versions-maven-plugin:2.7
• Added org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3
• Updated maven-assembly-plugin from 3.2.0 to 3.3.0
• Updated org.junit.jupiter:junit-jupiter-engine from 5.4.2 to 5.6.2
• Updated org.mockito:mockito-core from 2.24.0 to 3.3.3
• Updated org.junit.jupiter:junit-jupiter-params from 5.4.2 to 5.6.2
• Updated nl.jqno.equalsverifier:equalsverifier from 3.1.4 to 3.4.1
• Updated org.mockito:mockito-junit-jupiter from 2.23.4 to 3.3.3
• Updated org.junit.platform:junit-platform-runner from 1.4.2 to 1.6.2
• Updated org.apache.maven.plugins:maven-source-plugin from 3.0.1 to 3.2.1
• Updated org.itsallcode:openfasttrace-maven-plugin from 0.0.2 to 0.1.0
• Removed org.junit.jupiter:junit-jupiter-api
• Removed org.junit.platform:junit-platform-launcher

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