Fixed #36148 -- Enabled native tuple comparison lookups on SQLite 3.37+ and Oracle 23.4+.

VALUES must be explicitly specified when declaring a sequence of tuples
on SQLite < 3.37 but it's not required on >= 3.37.

See sqlite/sqlite@9289f51 which addressed the last remaining issue with
IN.

1 files changed, 11 insertions, 0 deletions

diff --git a/django/db/models/fields/tuple_lookups.py b/django/db/models/fields/tuple_lookups.py
index 1e77f095c8..b45bcaf2cd 100644
--- a/django/db/models/fields/tuple_lookups.py
+++ b/django/db/models/fields/tuple_lookups.py
@@ -27,6 +27,17 @@ class Tuple(Func):
     def __iter__(self):
         return iter(self.source_expressions)
 
+    def as_sqlite(self, compiler, connection):
+        if connection.get_database_version() < (3, 37) and isinstance(
+            first_expr := self.source_expressions[0], Tuple
+        ):
+            first_expr = first_expr.copy()
+            first_expr.function = "VALUES"
+            return Tuple(first_expr, *self.source_expressions[1:]).as_sql(
+                compiler, connection
+            )
+        return self.as_sql(compiler, connection)
+
 
 class TupleLookupMixin:
     allows_composite_expressions = True