Ideas for Version 2

[jeffgbutler]

Ideas for version 2 of MyBatis Dynamic SQL. Please feel free to add ideas or discuss.

• Require Java 17
• Remove Deprecated code from prior releases
• Allow CASE statements in ORDER BY (Function or statement for Order by clauses #821)
• Implement full boolean logic for joins (Conditional query after join on is supported. >=,<=,in #780)
• Add whenPresent versions of the paging methods (Suggestions for limt() and offset() improvements to SelectDSL #837)
• Adopt JSpecify nullability annotations
• Remove generic versions of DeleteDSL, SelectDSL, and UpdateDSL - only build the standard models (this will require an update to MyBatis generator)
• Rework the support for Spring Batch using mybatis-spring (it currently relies on the generic SelectDSL)
• Add some support for native R2DBC rendering (rendering for Spring template based R2DBC is already supported)
• Provide hooks into the renderers to allow easier customization of generated statements (Add ability to provide oracle hints #453, [Feature Request]: BeforeExecute, AfterExecute hook support #475)
• Investigate support for common table expressions (WITH statements) (How can i use Common Table Expressions (CTE)? #577). Not sure how feasible this is as we don't currently have an easy way to provide column specs for the tables defined by WITH statements