Release v2.14.0

✨ New Features

• Postgres array support.
• GENERATED ALWAYS VIRTUAL columns are now excluded from MutableColumns list for MySQL.
• Introduced the -skip-model and -skip-sql-builder flags to selectively skip model or SQL builder type generation.
• Added generator options -tables, -views, and -enums to only allow generation of specific tables, views, or enums.
• Added generator -model-json-tag option to include JSON tags in generated model types.

🐛 Bug Fixes

• Additional model import paths added to support generic types with non-standard inner types (issue).
• Fixed issue where SQL identifiers starting with a number were not correctly quoted.

Contributors

@switchupcb @markvai @joshkaplinsky @SanjaiyKumar @Sanjaiy @Andrei-hub11 @carsonkrueger @arjen-ag5

Release v2.13.0

✨ New Features

• Added support for SELECT_JSON statements (wiki).
• Added support for Blob / Bytea expressions.
• Introduced support for Strict Scan mode (wiki).
• Enabled LIMIT clause support in UPDATE queries for SQLite.
• Added DefaultColumns to the Table and View SQL builder.
• Jet generator now supports passing a direct database connection.
• Added support to skip SQL columns from generated types.
• Added support for exporting a ColumnList from a subquery.
• Enabled assignment of one ColumnList to another in INSERT and UPDATE queries.
• Introduced jet generator flags for package name customization for Model, Table, View, and Enum.

🐛 Bug Fixes

• Added missing PostgreSQL reserved keywords (issue)

Contributors

@Hasaber8 @sirmackan @TotallyGamerJet @galexrt @formica2 @jamius19

Release v2.12.0

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 and Token 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: New As method renames table alias for all the columns within ColumnList (wiki)
• Table Alias Removal: Table aliases can now be omitted from ColumnList and ProjectionList by passing an empty string to the As method (wiki)
• Postgres Character Type Constructors: New constructors for Postgres-specific character types, including Text, Char, and VarChar.
• Postgres Functions: Added support for DATE_TRUNC and GENERATE_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

Release v2.11.1

[Bug] Postgres ON CONFLICT DO NOTHING without conflict target does not appear in generated SQL (pr).

Special thanks to @BillBuilt for spotting the issue.

Release v2.11.0

[New] Postgres support for range types.
[New] Postgres support for materialized views.
[New] Sqlite support for generated columns.
[New] Support for OF in row locking clause.
[New] Postgres support for the FETCH FIRST clause.
[New] Support for NULLS_FIRST and NULLS_LAST sorting order.
[New] Default alias option for table SQL builder.
[New] Faster MySQL code generation for databases with very large numbers of tables.
[New] Postgres support for expression in the OFFSET clause.
[Bug] Invalid go identifiers ASCII characters are replaced with character description string.

New Contributors

@quirell, @ryym, @josephbuchma, @mattdowdell, @jupp0r, @realbucksavage, @sarkan-ag5

Release v2.10.1

[Bug] QRM doesn't group query result correctly if there are two model slices of the same type in the destination and one slice is aliased (issue, more info)
[Bug] Jet generator fails if MySQL column comment contains an ASCII control character (issue)
[Bug] Jet generator usage string shows the wrong version (issue)

Release v2.10.0

[New] Postgres support for GROUPING SET, ROLLUP, CUBE, and GROUPING operators (wiki)
[New] MySQL support for WITH ROLLUP and GROUPING operators (wiki)
[New] UseSchema method to replace targeted schema for table and view SQL Builder types (wiki)
[New] Generated columns are not part of the MutableColumns list anymore (issue)
[New] MySQL column comments are now included in generated files (issue)
[Bug] Generator fails if there is an enum with the same name in multiple Postgres schema (issue)
[Bug] QRM fails to group the result if the primary key is a custom type (issue)
[Bug] QRM fails to group the result if there are duplicate slices in the destination (issue)

Release v.2.9.0

[New] MySql insert row alias for duplicate key update statements (issue, wiki)
[New] MySql statement optimizer hints (issue, wiki)
[New] Postgres json literal (issue)
[Bug] Some mysql and sqlite conditional functions are not exported (issue)
[Bug] Missing SET method for ColumnTimez interface (pr)
[Bug] Reserved word RIGHT missing for postgres dialect (pr)

Release v.2.8.0

[New] CockroachDB support
[New] Table prefix and suffix for multi-tenant environment (issue)
[New] EXTRACT time/date support
[Bug] Ignore tables, views and enums does not work if dsn is present (pr)
[Bug] Statement Query and Exec methods can not be used with sql.Conn (issue)
[Bug] DebugSQL panics with Valuer types (issue)

Release v.2.7.1

[Fix] Poor performance when using Rows to scan the data (issue, wiki)
[New] Global AND and OR functions for better indentation of a complex conditions in the Go code and in the generated SQL (wiki)