What if your JDBC library actually knew what your database types were?

Not Object. Not getInt() with a column index and a prayer. Real types — int4range, jsonb, STRUCT, LIST<MAP<VARCHAR, INTEGER>>, GEOGRAPHY — modeled exactly as the database defines them, with full roundtrip fidelity.

That's what we built. Foundations JDBC is an open-source, MIT-licensed JDBC library for Java, Kotlin, and Scala. It gives you composable SQL fragments, typed row codecs, and test-time query verification — across PostgreSQL, MariaDB, DuckDB, Oracle, SQL Server, and DB2.

Today we're releasing 1.0.0-RC3.