Array Ops support for Postgres ad Hibernate 5

make_hibernate_array_again.java

public class PostgreSQLIndexedSearchFunction implements SQLFunction {
    @Override
    public boolean hasArguments() {
        return true;
    }

    @Override
    public boolean hasParenthesesIfNoArguments() {
        return true;
    }

    @Override
    public Type getReturnType(Type firstArgumentType, Mapping mapping) throws QueryException {
        return new BooleanType();
    }

    @Override
    public String render(
        Type firstArgumentType,
        List arguments,
        SessionFactoryImplementor factory
    ) throws QueryException {
        if (arguments.size() != 2) {
            throw new IllegalArgumentException("Function must be passed 2 arguments");
        }

        var array = (String) arguments.get(0);
        var search = (String) arguments.get(1);

        return String.format("%s @> ARRAY[%s]::varchar[]", array, search);
    }
}