jOOQ 3.18.0 release adds enhanced SQL diagnostics, SQL/JSON support, Oracle/PostgreSQL array features, and R2DBC 1.0 integration.
A tutorial on writing derived tables in jOOQ, explaining syntax, type safety considerations, and questioning if a derived table is always necessary.
Analyzes the performance difference between SQL's FILTER clause and CASE expressions in aggregate functions, using PostgreSQL benchmarks.
A guide to emulating window functions in MySQL 5.7 using local variables, highlighting the limitations and risks of this approach.
Explains the benefits of executing database queries with jOOQ's API instead of extracting SQL for use with other tools like JdbcTemplate.
Explores using the M4 macro processor to make SQL code more modular, reusable, and composable for managing large, complex codebases.
A guide for developers on when to use the jOOQ API versus writing native SQL, comparing pros and cons for each approach.
A tutorial on building a basic embedded SQL database in Zig using RocksDB, covering lexing, parsing, storage, and execution.
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
Analyzing conference session ratings using DuckDB and Jupyter Notebooks to demonstrate data wrangling and SQL on raw CSV data.
A technique for future-proofing SQL code by intentionally adding errors to catch unexpected changes in data or logic.
Explains pagination concepts, formulas, and implementation in C#/SQL, comparing it to infinite scrolling for efficient data loading.
Explores a powerful jOOQ feature: using implicit JOINs within explicit JOIN ON clauses for complex PostgreSQL metadata queries.
A guide to creating ASCII bar charts directly in PostgreSQL using SQL queries, eliminating the need for external visualization tools.
jOOQ 3.17 extends implicit join support to UPDATE and DELETE statements, simplifying DML queries with path expressions.
jOOQ 3.17 now treats SQL Conditions as Boolean Fields, simplifying queries and improving SQL standard compliance across dialects.
Explores various SQL dialects and jOOQ methods for returning data from INSERT, UPDATE, and DELETE statements using the RETURNING clause.
Explores jOOQ 3.17's new client-side computed columns feature, which allows creating dynamic, view-like columns in Java without SQL limitations.
Explains how to filter a SQL query's nested collection (ARRAY/MULTISET) by a specific value, using PostgreSQL and jOOQ examples.
