New Features
- Prepared Statement Caching (wiki)
VALUES
Statements Support (wiki)- Custom Expression and Operator Support: Users can now build custom expressions and operators using newly exposed
CustomExpression
andToken
functions. (wiki) - Row Expression Support
- Enum Model: List of all enum values are now listed in the generated enum model file (wiki)
- Postgres Comments: Generated files now include Postgres comments for table, columns and enums.
ColumnList
Table Re-Aliasing: NewAs
method renames table alias for all the columns withinColumnList
(wiki)- Table Alias Removal: Table aliases can now be omitted from
ColumnList
andProjectionList
by passing an empty string to theAs
method (wiki) - Postgres Character Type Constructors: New constructors for Postgres-specific character types, including
Text
,Char
, andVarChar
. - Postgres Functions: Added support for
DATE_TRUNC
andGENERATE_SERIES
functions. - Generator Column Metadata: Added new
HasDefault
metadata for columns.
Bug Fixes
- Postgres Array Detection: Fixed an issue with detecting Postgres arrays (issue)
- Interval Column Usage in UPDATE/INSERT SET: Interval columns can now be used in UPDATE and INSERT SET assignments (issue)
- SQL Builder Column Name conflict: Resolved naming conflicts for columns that share names with Jet types or methods by appending an underscore
_
to the end of the column field name (issue)
Contributors
@kblomster @josephbuchma @azdagron @realrunner @safaci2000 @BranislavLazic @VolkerLieber @jf9327 @MathieuKooiman