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 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 fine for almost everything until this.
>
> Anyone have any ideas?
> --
> You received this message because you are subscribed to the Google
> Groups "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to h2-database+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/h2-database/790f0e5f-1900-40b9-a886-a5aeeb85657bn%40googlegroups.com
> [1].
[1]
https://groups.google.com/d/msgid/h2-database/790f0e5f-1900-40b9-a886-a5aeeb85657bn%40googlegroups.com
https://groups.google.com/d/msgid/h2-database/790f0e5f-1900-40b9-a886-a5aeeb85657bn%40googlegroups.com?utm_medium=email_source=footer
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/d75e69e60c940a1263c8b4a6fe8786ed19730cfc.camel%40manticore-projects.com.