Error filtering with Postgres JSON column in parent entity

[white3km]

I'm trying to filter on a one to many relationship and I'm getting back a 500 error.

The basic scenario:

public class Alpha {
   private List<Beta> betas;
   private String config;

   @OneToMany(mappedBy = "alpha")
   public List<Beta> getBetas()
 
  // com.vladmihalcea.hibernate-types-52
  @Type(type = "json")
  public String getConfig()
}

public class Beta {
  private Alpha alpha;
  private String name;

  @ManyToOne
  public Alpha getAlpha()

  public String getName()
}

I can perform simple gets and filters on alpha but when I attempt something like api/alpha?filter=betas.name=='bob' then I get a 500 error and the log has org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type json.
The query generated by elide is something like the following
select distinct alpha.config, beta.name from alpha left outer join beta on alpha.id = beta.alpha_id where beta.name in (?)

If I grab that query and attempt it in pgadmin I get the error about running a distinct on a json column. Is there any way around this? A way to exclude certain columns from the distinct query but still have it returned in the results? Other suggestions?

[aklish]

Elide has a mechanism to override the JPQL generation for any filter predicate or model field/predicate pair:

https://elide.io/pages/guide/v6/16-performance.html#jpql-fragment-override

You might be able to leverage this to create an equality statement for json types.