id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
32082	"Support ""Row Values"" in where clause / filter"	Esteban C Borsani	nobody	"Using ""row values"" in the where clause is the only way to [https://use-the-index-luke.com/sql/partial-results/fetch-next-page make pagination efficient]. There is a variation that does not require row values, but it cannot make proper use of composite indices, which usually makes it slower than the more known offset/limit approach (which is already quite slow).

Unless I'm missing something, it seems the only way to implement this is using the QuerySet `extra` method, and I'd like to avoid that.

Here is a [https://www.sqlite.org/rowvalue.html#scrolling_window_queries sqlite example of row values], btw:

{{{
SELECT * FROM contacts
 WHERE (lastname,firstname) > (?1,?2)
 ORDER BY lastname, firstname
 LIMIT 7;
}}}

"	New feature	closed	Database layer (models, ORM)	dev	Normal	needsinfo			Unreviewed	0	0	0	0	0	0