Context Navigation

Changes between Initial Version and Version 1 of Ticket #35810, comment 2

-              initial
+              v1
     Select(
         "messages",
         queryset=Message.objects.order_by("created_at"),
+        queryset=Message.objects.order_by("created_at")[0],
         to_attr="lastest_message",
     ),
 …
     chat.*,
     latest_message.*
+FROM chat
 LEFT JOIN LATERAL (
     SELECT *
 …
     lastest_message=Message.objects.filter(
        chat_id=OuterRef("id"),
    ).order_by("created_at")[1]
+   ).order_by("created_at")[0]
+)
 }}}