[gardenhedge]

So you test against a different database technology than the one you software uses? I understand why that works but it seems odd

[quantified]

A real nice thing about Postgres and Mysql is that in the JVM world the H2 and HSQLDB engines have large compatibility, you can use them in-JVM for unit test speed in many cases. Doesn't help developing the SQL, does help with testing.

Snowflake, on the other hand, is just special.

[gardenhedge]

I assume this can't be done with Oracle DBs

[quantified]

I haven't explored myself, but I would bet they have good Oracle compatibility for at least the subset of semantics they support.