Is it possible to provide a class that includes some methods such as "IN()" to indirectly enhance the SqlProvider

[WONGHONGMING]

The class like this:

/** Actually, this is a bit like mapper.dtd */
public class SQLEnhancer {

    public static <E> String IN(Iterable<E> iterable, ForEachElementProvider<E> forEachElementProvider) {
        List<String> elementList = new ArrayList<>();
        int elementIndex = 0;
        for (E element : iterable) {
            elementList.add(forEachElementProvider.apply(element, elementIndex));
            elementIndex++;
        }
        return " IN (" + String.join(", ", elementList) + ")";
    }

    public static <E> String VALUES(Iterable<E> iterable, ForEachElementProvider<E> forEachElementProvider) {
        ......
    }

    public static String WHERE(String... sqlSlices) {
        ......
    }

    public static String iF(boolean condition, String sqlSlice) {
        ......
    }

    interface ForEachElementProvider<E> {

        String apply(E element, int elementIndex);
    }
}

Then import and use it like SqlBuilder:

import static xx.xx.xx.SQLEnhancer.*;

public class SqlProvider implements ProviderMethodResolver {

        public String findAllByIds(@Param("idList") List<String> idList) {
            return "SELECT * FROM user WHERE id" + IN(idList, (e, i) -> "#{idList[" + i + "]}");
        }

        public String deleteAllByIds(@Param("idList") List<String> idList) {
            // can also be used in  SQL class
            return new SQL()
                    .DELETE_FROM("user")
                    .WHERE("id" + IN(idList, (e, i) -> "#{idList[" + i + "]}"))
                    .toString();
        }
}

Additionally, this can also be used for string templates (unfortunately, Java23 has temporarily removed string templates).

[WONGHONGMING]

It seems that no one is interested in this, perhaps because it is too similar to the old SelectBuilder and SqlBuilder, so it is unnecessary.