spicychickensauce
I have found this article on how to handle has_many through relationships in ash: Modelling `through` relationships with Ash | sevenseacat.net
The approach taken is to use no_attributes? true and filter the relationship.
This works nicely when using ash_postgres, but not when using ash_sqlite.
The issue is (again) that it is implemented via a lateral join and that isn’t supported in sqlite.
Is there a good alternative?
Where Next?
Trending in Questions
Other Trending Topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
Bringing learning, work and compliance together since 1987.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Master modern tools, write cleaner code, and tackle real-world challenges.
Bringing learning, work and compliance together since 1987.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 2- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
zachdaniel
Hmm…I forget in what circumstances we have to use lateral joins for relationships with no attributes but I think that we can potentially carve out some cases where it’s not necessary depending on the filter? I’d have to look at the internals again. Could you make an issue with an example/repro?
spicychickensauce
Yeah, it seems like this should definitely be possible without any lateral join.
Ok, I’ve created an issue here with the adapted example repo from the blog: GitHub - spicychickensauce/ash_through_relationship_example at sqlite · GitHub
Thanks for taking a look