Add support for registering custom SQL functions when bootstrapping via JPA
Description
When bootstrapping via the Hibernate native mechanisms, we can easily supply a custom SQL function so that we can further use it in JPQL queries:
1
2
3
4
metadataBuilder.applySqlFunction(
"group_concat",
new StandardSQLFunction( "group_concat", StandardBasicTypes.STRING )
);However, if we bootstrap via JPA, the EntityManagerFactoryBuilderImpl does not provide a way to pass SQL functions, other than having to extend the Hibernate Dialect.
Therefore, I think we should have a mechanism which is similar to TypeContributions but for SQL functions.
Environment
None
Status
Assignee
Vlad Mihalcea
Reporter
Vlad Mihalcea
Components
Affects versions
5.2.17
5.3.0.Final
Priority
Major