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
Labels
None
backPortable
None
Suitable for new contributors
None
Requires Release Note
None
Pull Request
None
backportDecision
None
Components
Affects versions
5.2.17
5.3.0.Final
Priority
Major