Database-backed LiveView with assigns

I’m wondering, do people just tend to the stick the results of an ecto query into their assigns and, if not, what are the patterns people use to cleanly extract the required fields?

I have several more questions and thoughts around this but I thought I’d start here.

Normally put the result of the query into the assign. Some queries use Scrivener for pagination. Normally I use the templates view to apply the logic of what to render or not. But if you need only one or two fields, you can extract only that from the query.