Canvas app delegation: patterns that scale past 2000 rows

Delegation is Canvas's mechanism for pushing filters and lookups down to the data source instead of pulling everything into the client. Most makers know the yellow warning triangle; far fewer know the patterns that make delegation work in p