I was looking over Ecto and CockroachDB issue: (CaseClauseError) no case clause matching - #9 by Ankhers The basic need we have is that we need many select queries such as this: SELECT x, y, z FROM foobar f WHERE f.x = 'some-condition'; to be modified to include AS OF SYSTEM TIME, like this: SEL…

This is going to be a non-answer to your question but I think the proper way of handling this would be to create a CockroachDB adapter for ecto that can handle these scenarios. The good news is that ~99% of it should already be done. If you take a look at the official ecto adapters, you will notice…

Of course it does not compile right now. No one created the adapter that my comment is suggesting to make.

Hmm… there is this repo CockroachDB Ecto Adaptor — CockroachDB Ecto Adaptor v1.0.0 It’s been archived because it’s no longer needed (see GitHub - jumpn/ecto_cockroachdb: CockroachDB adaptor for Ecto 3.x · GitHub ) I guess I should figure out the functionality first before worrying about a package n…

Let me know if you would like help here. I do not have a project that uses cockroach right now, but I would like an excuse to use it. I might be able to throw something together that can be used as a base.

I mean, this is not only about adapter. Building an Ecto.Query doesn’t depend on used adapter in compile time. In order to add a new keyword, Ecto.Query struct has to be extended.

Right – I’ve just tracked this down in the code and I’ve reached the same conclusion. It seems like maybe what’s needed is more of an augmentation of Ecto.Query and not necessarily a completely separate database adapter. :thinking: I started inspecting the %Ecto.Query{} struct that gets generated…

Elixir Programming Language Forum

Modifying Ecto's SQL generation?

Questions & Help Questions

fuelen October 30, 2023, 2:26pm 3

This won’t even compile as the key is unknown.