Thanks for the feedback Lucas, glad you find the article useful! I did not try deploying this example to a LocalStack instance when I wrote the article. However looks like it should be possible to follow all the steps but using using awslocal and samlocal https://docs.localstack.cloud/user-guide/integrations/aws-sam/

Thanks for your kind words and tip! As of Hibernate 6 it should not be needed to extend the Hibernate SQL dialect classes in order to register a FunctionContributor following the steps described in this article. If there's a specific need to define the Hibernate dialect in your project, the approach described should be compatible with the standard Hibernate dialect definition classes. spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

Thanks for your comment! If I got it correctly, you would like to handle that your custom SQL functions returns an array. Then you could register your function with your aimed return type with a BasicTypeReference instance. private static final BasicTypeReference<String[]> RETURN_TYPE = new BasicTypeReference<>( "string[]" , String[].class, SqlTypes.ARRAY); As an example, a function called array_first_and_last that gets the first and last elements of the array would be somehow like this in the post example: select array [p.tags[ 1 ], p.tags[array_length(p.tags, 1 )]] from products p where ... After a correct registering and rendering implementation, you should be able to use it in a JPA repository as follows: @Query("select array_first_and_last(p.tags) as array from Product p where p.sku = :sku") String[] getFirstAndLastTagsBySku(@\Param( "sku" ) String sku); Hope it helps! Cheers 👍

Thank you! Glad you find it useful, this small feedback means a lot to me. Cheers! 👍