Build intermediary state, query API for query composition like Ecto

[drizzle-team]

Build intermediary state, query API for query composition like Ecto

[dankochetov]

Thank you for the feedback! We have query composition support on our roadmap 👍

[AlexBlokh]

hey, @izelnakri
Just to make sure we're on the same page, those query compositions are subqueries in SQL?

[izelnakri]

Hi @AlexBlokh, it is a representation/intermediary data for an SQL statement. Repo.all or Repo.one gets that fed in and generates the query, so you can make a query with subqueries inside an Ecto.Query struct.

[dankochetov]

We now support selecting and joining a subquery since 0.19.0 - https://github.com/drizzle-team/drizzle-orm/releases/tag/0.19.0

[AlexBlokh]

cc: @izelnakri
please have a look and provide feedback

[izelnakri]

Based on this: https://github.com/drizzle-team/drizzle-orm/releases/tag/0.19.0 It isn't what I had in mind as it evals JS context? Rather what I've meant is Ecto creates a intermediary query data structure in Elixir(or JS in this case) and feeds it to Repo.one or Repo.all but I'll have a look ;)

[dankochetov]

Closing this as we already have subquery and WITH support implemented. Feel free to open another issue if there's anything else you would like to see in the API.

[izelnakri]

its not the same, please have a look into ecto, every query is a intermediary data structure(Ecto.Query) before calling Repo.one or Repo.all, so one can compose queries.