Go Jet Jet Versions Save

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

Special thanks to @BillBuilt for spotting the issue.

[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

[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)

[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)

[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)

[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)

[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)

• [New] [Posgres] [Sqlite] UPDATE statement FROM clause support (issue, wiki)
• [New] [Postgres] [MySQL] DELETE statement USING clause support (issue, wiki)
• [New] [QRM] Prevent recursive scan if destination contains circular dependency (issue)
• [New] WITH RECURSIVE statement support (wiki)
• [New] BETWEEN operator support (wiki)
• [New] Aggregate functions DISTINCT operator support (issue)
• [New] [Postgres] DISTINCT ON clause support (wiki)
• [New] Ability to update alias of all sub-query(or CTE) projections (wiki)
• [New] Ability to exclude list of columns from sub-query(or CTE) projections (wiki)
• [New] Query logger function with additional execution details (issue, wiki)
• [New] [Postgres] Order set aggregate functions support (issue)
• [New] Generator flags to ignore tables, views and enums. (issue, wiki)
• [New] Automatic type cast for sized integer literals (issue)
• [Fix] Generator no longer supports MySQL 5.7 (issue)

• [New] Generator and SQL Builder support for SQLite databases.
• [New] Generator customization support (wiki).
• [New] Ability to exclude columns from ColumnList (wiki)
• [New] Generator can now connect to the database using DSN (wiki)
• [Fix] QueryContext panic when the scanned value is nil and the destination is a slice of primitive (issue91)
• [Fix] Special characters are not working in postgres password for generator (issue95), (issue34),

• LATERAL queries support (wiki)
• RawStatement support (wiki)
• Expose statement Rows method (wiki)
• Allow Raw helper to accept named arguments (wiki)
• Lossless decimal types conversion (wiki)
• Implicit CROSS JOIN support (wiki)
• SQL builder schema rename support. (wiki)
• [Bug][MySQL] UPDATE statement does not escape reserved word when MODEL is used (issue)
• Allow Bytea literal constructor to accept byte array as well as string
• New literal constructor functions: (wiki)
  • for each of the integer types - Int32(), UInt32(), Int64, UInt64(), etc..
  • for uuid literal - UUID()
  • for exact decimal literal - Decimal()