chango.git/django/db/backends/base/operations.py, branch devmain

Fixed #36492 -- Restored exact boolean lookup against literals on SQLite.

2026-06-03T20:57:18Z

Performance regression in 37e6c5b on SQLite. Just like MySQL, and presumably Oracle, which don't have a native boolean type and incidently store booleans in integer columns, indices on such columns cannot be used when explicit boolean literal equalities are omitted. Adapt the logic introduced by refs #32691 for MySQL to be used for all backends that don't support native boolean fields instead of special casing MySQL, SQLite, and Oracle in their own special way. Note that review of this work surfaced that SQLite's query planner also cannot make use of indices when dealing with expressions of form WHERE NOT (indexed_bool_field = false) but that's a long standing problem unrelated to the restorative work performed in this patch. Thanks Klaas van Schelven for the report.

Fixed #36727 -- Deprecated Field.get_placeholder in favor of get_placeholder_sql.

2026-03-13T00:01:02Z

The lack of ability of the get_placeholder call chain to return SQL and parameters separated so they can be mogrified by the backend at execution time forced implementations to dangerously interpolate potentially user controlled values. The get_placeholder_sql name was chosen due to its proximity to the previous method, but other options such as Field.as_sql were considered but ultimately rejected due to its different input signature compared to Expression.as_sql that might have lead to confusion. There is a lot of overlap between what Field.get_db_prep_value and get_placeholder_sql do but folding the latter in the former would require changing its return signature to return expression which is a way more invasive change than what is proposed here. Given we always call get_db_prep_value it might still be an avenue worth exploring in the future to offer a publicly documented interface to allow field to take an active part in the compilation chain. Thanks Jacob for the review.

Added DatabaseOperations.convert_trunc_expression() hook.

2026-02-28T15:01:08Z

Needed on MongoDB.

Refs #36822 -- Hoisted bulk_batch_size() implementations to base backend.

2026-01-16T14:15:53Z

Fixed #21961 -- Added support for database-level delete options for ForeignKey.

2025-10-18T13:03:50Z

Thanks Simon Charette for pair programming. Co-authored-by: Nick Stefan Co-authored-by: Akash Kumar Sen <71623442+Akash-Kumar-Sen@users.noreply.github.com> Co-authored-by: Simon Charette

Fixed #36616 -- Added DatabaseOperations.adapt_durationfield_value().

2025-09-23T16:36:49Z

Refs #27222 -- Adapted RETURNING handling to be usable for UPDATE queries.

2025-08-28T18:44:21Z

Renamed existing methods and abstractions used for INSERT … RETURNING to be generic enough to be used in the context of UPDATEs as well. This also consolidates SQL compliant implementations on BaseDatabaseOperations.

Refs #27222 -- Implemented BaseDatabaseOperations.return_insert_columns()/fetch_returned_insert_rows().

2025-08-28T18:44:21Z

Refs #36500 -- Rewrapped long docstrings and block comments via a script.

2025-07-23T23:17:55Z

Rewrapped long docstrings and block comments to 79 characters + newline using script from https://github.com/medmunds/autofix-w505.

Fixed #36085 -- Added JSONField support for negative array indexing on SQLite.

2025-05-14T11:21:18Z