Enum type in Query annotation does not work in in clause

[holmofy]

@Query("select category, text, count(id) as count" +
        " from table_name" +
        " where from_type in (:fromTypes)" +
        " group by text, category")
List<Stats> statsByFromType(Collection<FromType> fromTypes);

The FromType here is an enum type, but the in clause in the Query annotation cannot find the data.

The executed sql shows that FromType is converted to int type, but the actual string type is stored in the database

[mp911de]

Seems related to #630

[holmofy]

I also found that issue, but the problem is different. This problem occurs in the in clause. the parameter is a Collection.

I now use a compromise, which adds a default method. This default method calls the method of the Collection<String> parameter internally.

@Query("select category, text, count(id) as count" +
        " from table_name" +
        " where from_type in (:fromTypes)" +
        " group by text, category")
List< Stats > statsByFromTypeString(Collection<String> fromTypes);

default List<Stats> statsByFromType(Collection<PaperFromType> fromTypes) {
    return statsByCategoriesString(fromTypes.stream().map(PaperFromType::name).collect(Collectors.toList()));
}

But it's rather awkward to use. Can this collection parameter problem be solved?