Re: [h2] working around differences with h2 PSQL compatibilty

2024-04-07 Thread Andreas Reichel
Greetings! You could use JSQLParser to parse your query and then transpile/rewrite it into the specific dialect. If you would like to give me a Query sample then I will happily assist you with a template. Cheers Andreas On Sun, 2024-04-07 at 08:27 -0700, broccolai wrote: > hi! > > I'm offering p

[h2] working around differences with h2 PSQL compatibilty

2024-04-07 Thread broccolai
hi! I'm offering psql and h2 options in my software, as well as using h2 in my tests. But I'm having an issue when trying to store json data. H2 requires "FORMAT JSON" in the value for json but this syntax isn't allowed in PSQL. I'm trying to use the same queries between both which has been fi