• Added support for mysqlclient-sys 0.5.0
• Fix generating valid schema if a column is named table
• Fixed a regression with #[derive(Insertable)] if the same field type is used with different lifetime values

You can support the development of Diesel by:

• Contributing Code, Documentation or Guides. Checkout the planing for Diesel 2.4 for open tasks.
• Providing knowledge and help to maintain the MySQL/MariaDB backend. This is currently the only in-tree backend that is not used by any maintainers, so having someone around that actually uses this backend would be very helpful for the Diesel project.
• Answering questions in our discussion forum
• Reporting bugs in our issue tracker
• Helping triaging issues in our issue tracker
• Sponsoring the maintainers.

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.3.5...v2.3.6

• Fix another libmariadb related issue with time types
• Improve compile time error messages for #[derive(Insertable)]
• Bump supported version of sqlite-wasm-rs to 0.5.0
• Minor documentation fixes
• Make the returning_clauses_for_sqlite_3_35 feature enable the sqlite feature by default
• Include a fix for a nightly rust name resolution ambiguity

You can support the development of Diesel by:

• Contributing Code, Documentation or Guides. Checkout the planing for Diesel 2.4 for open tasks.
• Providing knowledge and help to maintain the MySQL/MariaDB backend. This is currently the only in-tree backend that is not used by any maintainers, so having someone around that actually uses this backend would be very helpful for the Diesel project.
• Answering questions in our discussion forum
• Reporting bugs in our issue tracker
• Helping triaging issues in our issue tracker
• Sponsoring the maintainers.

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.3.4...v2.3.5

• Fix an issue with breaking changes in libmariadb
• Fix documentation links for helper types
• Fix using #[diesel(embed)] with Option<Inner> types
• Fix documentation for concurrent migration runs

You can support the development of Diesel by:

• Contributing Code, Documentation or Guides. Checkout the planing for Diesel 2.4 for open tasks.
• Providing knowledge and help to maintain the MySQL/MariaDB backend. This is currently the only in-tree backend that is not used by any maintainers, so having someone around that actually uses this backend would be very helpful for the Diesel project.
• Answering questions in our discussion forum
• Reporting bugs in our issue tracker
• Helping triaging issues in our issue tracker
• Sponsoring the maintainers.

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.3.3...v2.3.4

• Fix displaying binds in instrumentations for #[derive(MultiConnection)]
• Support artifact attestation for binaries build for releases
• Stop using absolute paths in generated diesel.toml
• Explicitly qualify Ok in code generated by derives to avoid naming conflicts

Starting with Diesel-CLI 2.3.3 you can verify that you downloaded the correct binaries via GitHub's artifact attestation

gh attestation verify diesel_cli-x86_64-unknown-linux-gnu.tar.xz -R diesel-rs/diesel

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.3.2...v2.3.3

You can support the development of Diesel by:

• Contributing Code, Documentation or Guides. Checkout the planing for Diesel 2.4 for open tasks.
• Providing knowledge and help to maintain the MySQL/MariaDB backend. This is currently the only in-tree backend that is not used by any maintainers, so having someone around that actually uses this backend would be very helpful for the Diesel project.
• Answering questions in our discussion forum
• Reporting bugs in our issue tracker
• Helping triaging issues in our issue tracker
• Sponsoring the maintainers.

• Fixed an incompatibility with libmariadb versions shipped by debian
• Fixed docs.rs builds
• Fixed applying patch file schema.rs file with formatting
• Allow to compare DatabaseErrorKind values

(Diesel 2.3.1 did not contain any changes beside the version bump to retrigger the docs.rs build)

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.3.0...v2.3.2

You can support the development of Diesel by:

• Contributing Code, Documentation or Guides. Checkout the planing for Diesel 2.4 for open tasks.
• Providing knowledge and help to maintain the MySQL/MariaDB backend. This is currently the only in-tree backend that is not used by any maintainers, so having someone around that actually uses this backend would be very helpful for the Diesel project.
• Answering questions in our discussion forum
• Reporting bugs in our issue tracker
• Helping triaging issues in our issue tracker
• Sponsoring the maintainers.

This release includes a several large extensions to the query DSL provided by Diesel and also helps increases the number of platforms you can use Diesel on out of the box. Notable changes include:

• Improved query construction via #[derive(HasQuery)]
• Added support for window functions
• Using SQLite with WASM in your browser
• Extended support for various types, functions and operators in the PostgreSQL backend
• Support for JSON and JSONB in the SQLite backend

See the release blog for the full announcement

You can support the development of Diesel by:

• Contributing Code, Documentation or Guides. Checkout the planing for Diesel 2.4 for open tasks.
• Providing knowledge and help to maintain the MySQL/MariaDB backend. This is currently the only in-tree backend that is not used by any maintainers, so having someone around that actually uses this backend would be very helpful for the Diesel project.
• Answering questions in our discussion forum
• Reporting bugs in our issue tracker
• Helping triaging issues in our issue tracker
• Sponsoring the maintainers.

• Added limit() and offset() DSL to combination clauses such as UNION
• Fixed #[derive(Identifiable)] ignoring attribute #[diesel(serialize_as)] on primary keys
• Added embedded struct support for AsChangeset via #[diesel(embed)]
• Added a #[diesel(skip_update)] attribute for the AsChangeset derive to skip updating a field present in the struct
• Support for libsqlite3-sys 0.35.0
• Add support for built-in PostgreSQL range operators and functions
• Support for postgres multirange type
• Added diesel::r2d2::TestCustomizer, which allows users to customize their diesel::r2d2::Pools in a way that makes the pools suitable for use in parallel tests.
• Added support for built-in PostgreSQL range operators and functions
• Added support for various built-in PostgreSQL array functions
• Added Json and Jsonb support for the SQLite backend.
• Added a #[diesel::declare_sql_function] attribute macro to easily define support for multiple sql functions at once via an extern "SQL" block
• Support [print_schema] allow_tables_to_appear_in_same_query_config = "fk_related_tables" to generate separate allow_tables_to_appear_in_same_query! calls containing only tables that are related through foreign keys. (Default: "all_tables".) It is not possible to build queries using two tables that don't appear in the same allow_tables_to_appear_in_same_query! call, but that macro generates O(n²) rust code, so this option may be useful to reduce compilation time. (#4333)
• Added wasm32-unknown-unknown target support for sqlite backend.
• Add support for the CAST operator
• Support [print_schema] allow_tables_to_appear_in_same_query_config = "none" to generate no allow_tables_to_appear_in_same_query! calls. (Default: "all_tables".). (#4333)
• Add [print_schema] pg_domains_as_custom_types parameter to generate custom types for PostgreSQL domains that matches any of the regexes in the given list. (Default: [].) This option allows an application to selectively give special meaning for the serialization/deserialization of these types, avoiding the default behavior of treating the domain as the underlying type. (#4592)
• Add support for batch insert and upsert statements with returning for SQLite
• Add support for window functions and aggregate expressions.

• Fixed diesel thinking a.eq_any(b) was non-nullable even if a and b were nullable.
• Generate InstrumentationEvent::BeginTransaction for immediate and exclusive transactions in SQLite
• Use a single space instead of two spaces between DELETE FROM.
• Diesel CLI now ensures that migration versions are always unique. If it fails to generate a unique version, it will return an error. The new version format remains compatible with older Diesel versions.
• Updated ipnetwork to allow version 0.21.

• Use distinct DIESEL_LOG logging filter env variable instead of the default RUST_LOG one (#4575)
• The minimal supported Rust version is now 1.86.0

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.2.0...v2.3.0

• Added support for libsqlite3-sys 0.35.0
• Fixed a wrong oid for the oid[] type in the PostgreSQL backend
• Worked around an issue with broken nullable detection with certain versions of libmysqlclient shipped by ubuntu
• Improved compiler errors in many more cases

You can support the development of Diesel by contributions or by sponsoring the project on GitHub

We are looking for input on a newly designed derive to make constructing queries easier. See here for details.

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.2.11...v2.2.12

• Disallow mixing aggregate and non-aggregate expressions in DISTINCT ON clauses
• Fixed an item referenced by a non-absolute path in #[derive(MultiConnection)]
• Improved compiler errors in some cases
• Improved the documentation for creating SqliteConnections for concurrent applications

You can support the development of Diesel by contributions or by sponsoring the project on Github

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.2.10...v2.2.11

• Support for libsqlite3-sys 0.33.0
• Fixed potential ambiguities in code generated by various derives

You can support the development of diesel by contributions or by sponsoring the project on Github

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.2.9...v2.2.10

• Fix an issue where diesel migration generate --diff-schema incorrectly uses the primary key of table B as the referenced column rather than the primary key of table A when B has a foreign key pointing to table A.
• Bump maximal supported libsqlite3-sys version to 0.32.0 and add explicit feature entries for the uuid and serde_json feature.
• Fixed an issue where diesel generated unnamed prepared statements would fail with an unanmed prepared statement not found error with pgbouncer.
• Fix an issue with converting ipnet::Ipnet values with an subnet to SQL values

You can support the development of diesel by contributions or by sponsoring the project on Github

Full Changelog: https://github.com/diesel-rs/diesel/compare/v2.2.8...v2.2.9