SQL DSL (Domain Specific Language) for Kotlin and Java. Supports rendering for MyBatis or Spring JDBC Templates
APACHE-2.0 License
Bot releases are hidden (Show)
Published by jeffgbutler 5 months ago
This is a small maintenance release with the following changes:
Important: This is the last release that will be compatible with Java 8.
The full list of changes is available here: https://github.com/mybatis/mybatis-dynamic-sql/milestone/14?closed=1
Please find the full release notes here: https://mybatis.org/mybatis-dynamic-sql/docs/CHANGELOG.html
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.5.2</version>
</dependency>
Published by jeffgbutler 6 months ago
This is a minor release with a few enhancements. The most important enhancement is that the library now supports CASE expressions in select statements. The rendering process was also refactored significantly. This should have no impact on most users.
Important: This is the last release that will be compatible with Java 8.
The full list of changes is available here: https://github.com/mybatis/mybatis-dynamic-sql/milestone/13?closed=1
Please find the full release notes here: https://mybatis.org/mybatis-dynamic-sql/docs/CHANGELOG.html
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.5.1</version>
</dependency>
Published by jeffgbutler over 1 year ago
This release includes many new features and one potential breaking change.
In addition, much of the deprecated code in prior releases was removed.
If you create reusable where clauses with the library, and use the WhereSupplier
class, the syntax has changed. This change was required when we added support for having
clauses (see below). Please see the release notes for full details.
having
clauses. Having clauses have the same syntax and capabilities as where clauses. You can also write standalone having clauses if you have a need to reuse them.The full list of changes is available here: https://github.com/mybatis/mybatis-dynamic-sql/milestone/12?closed=1
Please read the full release notes for details: https://mybatis.org/mybatis-dynamic-sql/docs/CHANGELOG.html#release-1-5-0-april-21-2023
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.5.0</version>
</dependency>
Published by jeffgbutler about 2 years ago
This maintenance release includes a few new features and one important change.
The next release of the library will be version 1.5.0 and we will remove all deprecated code in that release.
The library will now throw a NonRenderingWhereClauseException
if a where clause is coded in any statement, but fails to render because all optional conditions have been dropped. We have made this change out of an abundance of caution to prevent statements that accidentally impact all rows in a table (for example, a delete statement could delete all rows in a table).
The default behavior can be modified either through global configuration, or on a statement by statement basis. Please see the documentation page about library configuration for details here: https://mybatis.org/mybatis-dynamic-sql/docs/configuration.html.
DynamicSqlException
or some subclass of DynamicSqlException
The full list of changes is available here: https://github.com/mybatis/mybatis-dynamic-sql/issues?q=milestone%3A1.4.1+
Please read the full release notes for details: https://mybatis.org/mybatis-dynamic-sql/docs/CHANGELOG.html
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.4.1</version>
</dependency>
Published by jeffgbutler over 2 years ago
This release includes the following enhancements:
With this release, the Kotlin DSL is very close to native SQL. It is awesome - give it a try!
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.4.0</version>
</dependency>
Published by jeffgbutler almost 3 years ago
This minor release includes the following enhancements:
SqlColumn
. The type will be rendered properly for MyBatisAliasableSqlTable
meta-model classgroupBy
and orderBy
methods on the SELECT statementThe full list of changes is available here: https://github.com/mybatis/mybatis-dynamic-sql/issues?q=milestone%3A1.3.1+
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.3.1</version>
</dependency>
Published by jeffgbutler over 3 years ago
This release includes the following major enhancements:
There are many other minor updates, and deprecated code from prior releases has been removed.
The full list of changes is available here: https://github.com/mybatis/mybatis-dynamic-sql/issues?q=milestone%3A1.3.0+
Important Note: This release contains two breaking changes that might impact some users in rare cases. Please read the full release notes for details: https://mybatis.org/mybatis-dynamic-sql/docs/CHANGELOG.html
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.3.0</version>
</dependency>
Published by jeffgbutler about 4 years ago
This small release contains the following bug fix:
And the following enhancements:
There are a few other small changes. You can see the full list here: https://github.com/mybatis/mybatis-dynamic-sql/issues?q=milestone%3A1.2.1+
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.2.1</version>
</dependency>
Published by jeffgbutler about 4 years ago
This release has a few major themes:
Several methods - especially some insert methods - have been deprecated in favor of more consistency across all runtimes and languages. All deprecated methods have direct replacements. All deprecated code will be removed in the next release.
There are quite a few other improvements. You can see the full list here: https://github.com/mybatis/mybatis-dynamic-sql/issues?q=milestone%3A1.2.0+
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.2.0</version>
</dependency>
Published by jeffgbutler almost 5 years ago
This release has two enhancements:
Also fixed one bug:
Detail about these changes can be viewed here:
https://github.com/mybatis/mybatis-dynamic-sql/issues?q=is%3Aclosed+milestone%3A1.1.4
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.1.4</version>
</dependency>
Published by jeffgbutler about 5 years ago
This release has three major enhancements:
For information about the new lambda based usage pattern, see this page: https://mybatis.org/mybatis-dynamic-sql/docs/mybatis3.html
For information about Kotlin support when using MyBatis, see this page: https://mybatis.org/mybatis-dynamic-sql/docs/kotlinMyBatis3.html
For information about Kotlin support when using Spring JDBC Template, see this page: https://mybatis.org/mybatis-dynamic-sql/docs/kotlinSpring.html
The full list of changes can be viewed here:
https://github.com/mybatis/mybatis-dynamic-sql/issues?q=is%3Aclosed+milestone%3A1.1.3
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.1.3</version>
</dependency>
Published by jeffgbutler over 5 years ago
This release includes several enhancements related to increasing user flexibility including:
List
based conditions has been changed to support Collection
instead of List
By far, the most important enhancements are related to making it easier to create very dynamic select statements with complex where clauses. There is a new page in the online documentation showing the new capabilities here: http://www.mybatis.org/mybatis-dynamic-sql/docs/complexQueries.html
The full list of changes can be viewed here:
https://github.com/mybatis/mybatis-dynamic-sql/issues?q=is%3Aclosed+milestone%3A1.1.2
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.1.2</version>
</dependency>
Published by jeffgbutler over 5 years ago
This release includes many enhancements and one small bug fix.
The most important enhancements are as follows:
The full list of changes can be viewed here:
https://github.com/mybatis/mybatis-dynamic-sql/issues?q=is%3Aclosed+milestone%3A1.1.1
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.1.1</version>
</dependency>
Published by jeffgbutler over 6 years ago
This release includes many enhancements and two bug fixes.
The most important enhancement is the introduction of optional conditionals. They allow a where clause to be created that varies based on the value of the input parameters. See the following page for details and examples:
http://www.mybatis.org/mybatis-dynamic-sql/docs/conditions.html
The full list of changes can be viewed here:
https://github.com/mybatis/mybatis-dynamic-sql/issues?q=is%3Aclosed+milestone%3A1.1.0
All artifacts are available in Maven central under these coordinates:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.1.0</version>
</dependency>
Published by jeffgbutler almost 7 years ago
First release of MyBatis Dynamic SQL - an SQL generator/templating utility for MyBatis and Spring JDBC templates.
Available in maven central here:
<dependency>
<groupId>org.mybatis.dynamic-sql</groupId>
<artifactId>mybatis-dynamic-sql</artifactId>
<version>1.0.0</version>
</dependency>