Hi, Spring fans! In this conversation, Josh Long explores how JOOQ turns SQL into a type-safe, fluent Java language—making complex database work safer, cleaner, and far more expressive. They cover everything from dynamic SQL transformation and cross-dialect support to low-level security, stored procedures, views, and the realities of working with modern databases like DuckDB, ClickHouse, Redshift, and more.

Along the way, Lucas reflects on the origins of JOOQ, why he built it, and how the project has evolved from a clever Java DSL into a serious platform for enterprise-grade database development. The discussion also touches on AI-assisted debugging, the enduring relevance of SQL, and how strong typing can dramatically reduce mental overhead for developers and DBAs alike.

If you care about databases, Java, or writing better software with less friction, this episode is a masterclass in thoughtful engineering and pragmatic elegance.