I don't think this answer is necessarily going to convince you in any way to use Ash 😅. But it felt worth explaining how it works.
You don't have to leverage the AshPostgres
data layer necessarily.
Resources & actions etc. can be leveraged just for their interface tooling,
and you can make queries with Ecto manually. Most people, even people who are
very picky about their SQL, often end up not doing that because AshPostgres makes
smart choices for you that are hard to replicate manually. What this is talking
about when I refer to it as an insane thing to support isn't that we generate
pathological queries, its the complexity in query building that we take on to