Context Navigation

Changes between Initial Version and Version 1 of Ticket #33706

initial	v1
84	84	- do you see any pitfalls or caveats to this method of performing the query?
85	85	- if there are no pitfalls, or they can be resolved do you think that this could be the default way of annotating calculations in django? The examples are in postgresql, not sure about the other supported database engines compatibility.
	86
	87	Some links:
	88	- https://www.sisense.com/blog/reuse-calculations-in-the-same-query-with-lateral-joins/
	89	- https://stackoverflow.com/questions/58094851/lateral-join-in-django-queryset-in-order-to-use-jsonb-to-recordset-postgresql-f