Is there way to mark Rails scope as loaded (and pass it the records array) to avoid extra db calls?

I have a method which returns an array of records which I can’t keep as a pure scope because I need to do complex in-memory filtering not easy with pure SQL.

accounts = current_user.accounts.select {|a| a.some_complex_method }

But I need to be able to scope-chain it for other purposes later, so I end up re-scoping it:

accounts = Account.where(id: accounts.map(&:id)).order(‘name asc’)

Unfortunately this issues a 2nd db call which isn’t needed because all data for the subsequent scope chains should be available from the original result.

Is there a way for me to build an in-memory chainable scope for data returned previously and already converted to array, without making extra db calls? I realize stuff like offset will not reliably work with this approach, but I don’t need it for my use case.

Eugene

looks like you want a repository on top of activerecord and afaik it’s not really feasible.
what i’d suggest in your particular case is to retrieve records in question once and then filter/order them on your own.