Use other queries in joins?

[hubertlepicki]

Check out this answers @josevalim kindly gave me:

Ecto and computed virtual fields

Let’s suppose I have Account model that has_many Transactions. I want to load the list of Accounts, with an average transaction, in one SQL query. What is the correct way of doing that in Ecto? I am using Ecto 2.0.

Ecto and preloading most recent record from association

Well yeah, I could do that, but I don’t want to. So someone takes all the trouble of writing an answer and your reply is “I don’t want to”? Can you at least clarify what is wrong with his response? It includes everything you need to make it work: def with_top_versions(query) do post_versions = from pv in PostVersions, limit: 10 from query, preload: [post_versions: post_versions] end Post |> Post.with_top_versions I had dealt with this sort of crap for seven years using ActiveRecord. E…