Fork me on GitHub

Release notes

Release History

Version Date Description
3.0.2 2021-06-03  
3.0.1 2020-09-10  
3.0.0 2019-02-10 Update to Java 8
2.1.7 2017-04-21  
2.1.6 2016-12-18  
2.1.5 2016-09-20  
2.1.4 2016-07-01  
2.1.3 2016-05-30  
2.1.2 2016-01-30  
2.1.1 2015-07-01  
2.1.0 2015-04-16 Relicense to Apache License
2.0.13 2014-12-27  
2.0.12 2012-10-01  
2.0.11 2012-01-10  
2.0.10 2011-10-19  
2.0.9 2011-08-25  
2.0.8 2011-04-22  
2.0.7 2011-03-07  
2.0.6 2009-10-12  
2.0.5 2009-05-24  
2.0.4 2008-10-05  
2.0.3 2008-06-05  
2.0.2 2008-04-28  
2.0.1 2008-04-07  
2.0.0 2008-03-31  

Release 3.0.2 – 2021-06-03

Type Changes By
Update Add system property which allows setting the default list item separator to include a trailing space. jahlborn
Update Add convenience methods for constructing OrderObject instances. Add documention about using OrderObject to control null ordering. jahlborn

Release 3.0.1 – 2020-09-10

Type Changes By
Update Added Conditions and Expressions classes with static methods for generating most condition and expression types. Useful for static imports for writing more succinct code. Fixes 27. jahlborn
Update Add support for setting the constraint check time and setting the delete/update referential action for foreign key constraints. jahlborn
Update Add more useful info to some validation failures. Fixes 26. jahlborn

Release 3.0.0 – 2019-02-10

Type Changes By
Update SqlBuilder now requires a Java 8+ runtime. As part of this update, all dependencies have been updated to their latest versions. jahlborn
Update The separate common-util dependency has been removed. The few classes which were utilized from that dependency are now included in this project directly. jahlborn
Update Add convenience methods to convert Java 8 Temporal types into jdbc date/time escape syntax. jahlborn

Release 2.1.7 – 2017-04-21

Type Changes By
Add Add the EXTRACT expression (thanks to Andrey Karepin). Fixes 4. jahlborn
Add Add support for window functions (ideas from Andrey Karepin). Fixes 3. jahlborn

Release 2.1.6 – 2016-12-18

Type Changes By
Update Add the BETWEEN condition. Fixes 19. jahlborn

Release 2.1.5 – 2016-09-20

Type Changes By
Update Add a few convenience methods for RejoinTable and table aliases. jahlborn
Update Add support for some custom postgresql binary conditions (ilike, similar to, and posix regex matching). Fixes 18. jahlborn

Release 2.1.4 – 2016-07-01

Type Changes By
Update Add OSGi support to jar manifest. Fixes 20. jahlborn

Release 2.1.3 – 2016-05-30

Type Changes By
Update Add support for sqlserver TOP syntax as custom SQL. Fixes 18. jahlborn
Update Add support for SQL 2008 OFFSET and FETCH NEXT clauses in SELECT queries. jahlborn
Update Add support for cross schema foreign key column references. Fixes 17. jahlborn

Release 2.1.2 – 2016-01-30

Type Changes By
Update New site style! jahlborn
Update Initial foray into SQL99 syntax with Common Table Expression support. Fixes 15. jahlborn
Update Add system property for using SQL boolean literals for boolean values. Fixes 16. jahlborn

Release 2.1.1 – 2015-07-01

Type Changes By
Update Add a framework for enabling SqlBuilder queries to support custom SQL syntax. Add a few common database-specific customizations. Fixes 14. jahlborn
Update Add NamedParamObject which supports the "named" param syntax used by some SQL or SQL-like frameworks. Fixes 5. jahlborn
Add Add CheckConstraint for handling table/column CHECK constraints. jahlborn

Release 2.1.0 – 2015-04-16

Type Changes By
Add OpenHMS relicenses to Apache License, 2.0! jahlborn

Release 2.0.13 – 2014-12-27

Type Changes By
Add Add QueryPreparer.ListPlaceHolder to simplify working with lists of PlaceHolders (common in IN expressions). Fixes 13. jahlborn

Release 2.0.12 – 2012-10-01

Type Changes By
Update Add support for arbitrary column type qualifiers (e.g. scale and precision). Fixes 3536960. jahlborn

Release 2.0.11 – 2012-01-10

Type Changes By
Add Added the AddColumnAction to the AlterTableQuery, thanks to Eric Fennell. jahlborn
Update Add support for column default values. jahlborn

Release 2.0.10 – 2011-10-19

Type Changes By
Update Add more flexible table aliasing: handle Table with no alias and allow DbTable alias to be passed in constructor. Fixes 3421696. jahlborn
Update Add SelectQuery.addCustomJoin(Object) for fully customizable join clauses. Fixes 3421713. jahlborn
Update Allow ComboCondition,UnaryCondition,BinaryCondition,ComboExpression to have custom operators. Fixes 3422262. jahlborn
Update Add option to disable wrapping parentheses in Conditions and Expressions which utilize them. Fixes 3422262. jahlborn

Release 2.0.9 – 2011-08-25

Type Changes By
Update Make DbSpec the factory for all other DbObject classes. jahlborn
Update Add methods/constructors to enable more flexible usage of DbObject classes with custom subclasses (thanks to Douglas Russell for some code contributions). Fixes 3397693. jahlborn

Release 2.0.8 – 2011-04-22

Type Changes By
Fix Fix date tests so that they are TimeZone agnostic. Fixes 3237822. jahlborn
Update Add support for updatable ResultSets to QueryReader. jahlborn

Release 2.0.7 – 2011-03-07

Type Changes By
Update Make Constraints first class citizens of the dbspec model. Add ConstraintClause and enhance various constructs to use improved constraint implementations. Deprecated simplified constraint support in CreateTableQuery and AlterTableQuery. Fixes 3125765. jahlborn

Release 2.0.6 – 2009-10-12

Type Changes By
Fix Add hasParens() method to NestableClause so that InCondition can accurately determine if the values need to be wrapped in parens or not. Fixes 2817484. jahlborn

Release 2.0.5 – 2009-05-24

Type Changes By
Update Add support for additional query "set operators" (EXCEPT, INTERSECT), and add support for mixed usage of said operators. Fixes 2794171. jahlborn
Update Add UnaryCondition EXISTS and UNIQUE operators. jahlborn
Update Minor cleanups for some of the generic types. jahlborn
Fix Fix isEmpty implementation for Subquery. jahlborn
Update Don't put double parens around IN condition with subexpression. jahlborn

Release 2.0.4 – 2008-10-05

Type Changes By
Fix Handle BigDecimal/BigInteger instances better in NumberValueObject.isFloatingPoint. jahlborn
Fix Fixed handling of boolean values (handle them as numbers because Sql92 has no notion of a real boolean type), implemented BooleanValueObject. Fixes 2138885. jahlborn

Release 2.0.3 – 2008-06-05

Type Changes By
Add Added support for view creation (CreateViewQuery) and deletion (DropQuery.Type.VIEW). jahlborn

Release 2.0.2 – 2008-04-28

Type Changes By
Fix Change how state is maintained during query validation. Use the ValidationContext instead of a few collections in order to enable more complicated subquery handling. This change allows subqueries to be validated correctly and opens the door for sub-clause validation. Fixes 1943120. jahlborn
Update Extend the unit test coverage. jahlborn

Release 2.0.1 – 2008-04-07

Type Changes By
Update Fold numeric conversions into normal value conversions. jahlborn

Release 2.0.0 – 2008-03-31

Type Changes By
Add Initial open source release. jahlborn