Array join type (for clickhouse)

[Ruslan Doga]

👋

ClickHouse supports array joins: https://clickhouse.com/docs/en/sql-reference/statements/select/array-join/

Would it be OK to open a PR to either add `:array` join type support into Ecto DSL?

[Greg Rychlewski]

Have you already worked out the PR on your own? If i'm reading the docs correct instead of a table joining a table it's a table joining one of its own columns. 

I'm not sure how much the planner would have to change to support that.

[Jon Rowe]

FWIW a table joining one of its own columns is already supported sort of, for example this is a cross join in postgres and is supported:

   from(t in Table, cross_join: e  in fragment(“jsonb_array_elements(?)”, t.jsonb_array), select: t.id, e.id)

This does seem like something that belongs in an adapter though considering its a non standard SQL extension?

--

You received this message because you are subscribed to the Google Groups "elixir-ecto" group.

To unsubscribe from this group and stop receiving emails from it, send an email to elixir-ecto...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/elixir-ecto/127a1eae-f8fb-40eb-ad89-c8ff0e0ab588n%40googlegroups.com.

[Ruslan Doga]

Right now there is no way to modify Ecto DSL from the adapter. That is, there is nothing we can do in the adapter to support queries like

    "events"

    |> join(:array, [e], ...)

or

    from e in "events", array_join: ...

as they break before arriving into the adapter.

Also, is LATERAL JOIN an SQL standard? :)