We have started the integration today and since currently we don’t have much write heavy load we are using PGWire in JAVA using JPA. One issue we are facing is that our service had integrated spring batch and spring batch tries to store meta data regarding any batch jobs using JPA but since quest db uses different dialect when it comes to create table queries, our service won’t start giving below error :

Caused by: org.postgresql.util.PSQLException: ERROR: found [tok='(', len=1] ',' or ')' expected

This error is generated when spring batch framework tries to create a new table for it’s usage using PGWire. This is also happening for QuestDB tables but currently I am manually creating them but since I am not aware of spring batch table schemas, is there any workaround this?

We’re quite far away to support all syntax JPA can generate