Support exact lookups where lhs is CompositePrimaryKey and rhs is Subquery

[Jacob Walls]

This query is not currently supported (models drawn from composite_pk test suite):

subquery = Subquery(User.objects.filter(pk=OuterRef("pk")).values("pk"))
queryset = Comment.objects.filter(pk=subquery)

---

  File "/django/source/django/db/models/fields/tuple_lookups.py", line 56, in get_prep_lookup
    self.check_rhs_is_supported_expression()
  File "/django/source/django/db/models/fields/tuple_lookups.py", line 79, in check_rhs_is_supported_expression
    raise ValueError(
ValueError: 'exact' subquery lookup of 'pk' only supports OuterRef and QuerySet objects (received 'Subquery')

---

The version without explicit Subquery (and adding [:1]) also fails:

  File "/django/source/django/db/models/lookups.py", line 384, in get_prep_lookup
    raise ValueError(
ValueError: The QuerySet value for the exact lookup must have 2 selected fields (received 1)

On Oracle the failure looks like this, but this is probably a separate issue:

django.db.utils.DatabaseError: ORA-01796: this operator cannot be used with lists
Help: https://docs.oracle.com/error-help/db/ora-01796/

---

​PR to kick off discussion addresses all but the Oracle failure, which might worth looking at separately, perhaps a deeper issue?

[Jacob Walls]

On the PR Simon ​suggested fixing this closer to the root of the problems with Subquery resolution. If someone else has capacity, feel free to reassign, it might be a while before I can get to it.

[Jacob Walls]

​PR

[Simon Charette]

Left some comments about the preferred usage of a feature flag for tuple comparison against subquery support but otherwise the patch looks great.

[Sarah Boyce <42296566+sarahboyce@…>]

In de7bb7e:

Refs #36210 -- Added missing limits in Subquery tests.

[Sarah Boyce <42296566+sarahboyce@…>]

In fd569dd:

Fixed #36210, Refs #36181 -- Allowed Subquery usage in further lookups against composite pks.

Follow-up to 8561100425876bde3be4b2a22324655f74ff9609.

Co-authored-by: Simon Charette <charette.s@…>

[Sarah Boyce <42296566+sarahboyce@…>]

In 181e3bd7:

Refs #36210 -- Corrected output_field comparison in Subquery.resolve_expression().

Regression in fd569dd45bf0746378faf7f65172497f21ed27f0.

[Sarah Boyce <42296566+sarahboyce@…>]

In eed7f442:

Refs #36210 -- Added release note for further subquery support for composite pks.

Follow-up to fd569dd45bf0746378faf7f65172497f21ed27f0.