Java, SQL and jOOQ.

Java, SQL and jOOQ.by lukaseder·7 May 2026

ANTI JOIN is a very useful operator from relational algebra. Regrettably, only few dialects support it in terms of SQL syntax, as we’ve written earlier.

Java, SQL and jOOQ.by lukaseder·4 May 2026

Some SQL operators are as esoteric as they’re powerful. One of the oldest operator that you’ve likely hardly ever used in real world applications is NATURAL JOIN which is the default in relational...

0

14%plop score, above 14 percent of recent articles

Java, SQL and jOOQ.by lukaseder·27 Mar 2026

One of jOOQ’s most popular feature is the out-of-the-box debug logging experience. jOOQ developers find this feature very useful when developing their applications.

0

5%plop score, above 5 percent of recent articles

Java, SQL and jOOQ.by lukaseder·11 Aug 2025

When implementing the awesome MULTISET operator in jOOQ, its implementation mostly relied on SQL/JSON support of various RDBMS.

0

3%plop score, above 3 percent of recent articles

Java, SQL and jOOQ.by lukaseder·27 Mar 2025

ARRAY types are a part of the ISO/IEC 9075 SQL standard. The standard specifies how to: - Construct arrays - Nest data into arrays (e.g.

0

10%plop score, above 10 percent of recent articles

Java, SQL and jOOQ.by lukaseder·28 Feb 2025

Every product manager knows this situation: - A user works with feature X1 . - They find a limitation / bug / quirk and want to work around it.

0

42%plop score, above 42 percent of recent articles

Java, SQL and jOOQ.by lukaseder·3 Jun 2024

A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: - ClickHouse - CockroachDB - DuckDB - Firebird - H2 - HSQLDB - PostgreSQL -...

0

3%plop score, above 3 percent of recent articles

Java, SQL and jOOQ.by lukaseder·1 Mar 2024

I’ve blogged about generic ways of getting top 1 or top n per category queries before on this blog.

0

4%plop score, above 4 percent of recent articles

Java, SQL and jOOQ.by lukaseder·10 Jan 2024

One of jOOQ’s key features so far has always been to render pretty much exactly the SQL that users expect, without any surprises – unless some emulation is required to make a query work, of course.

0

1%plop score, above 1 percent of recent articles

Java, SQL and jOOQ.by lukaseder·28 Dec 2023

jOOQ 3.19 finally delivers on a set of features that will greatly simplify your queries further, after jOOQ 3.11 introduced implicit to-one joins: What are these features? Many ORMs (e.g.

0

11%plop score, above 11 percent of recent articles

Java, SQL and jOOQ.by lukaseder·20 Dec 2023

In MySQL, you cannot do this: create table t (i int primary key, j int); insert into t values (1, 1); update t set j = (select max(j) from t) + 1; The UPDATE statement will raise an error as...

Java, SQL and jOOQ.by lukaseder·15 Dec 2023

New Dialects It’s been a few releases since we’ve added support for new dialects, but finally some very interesting RDBMS of increasing popularity have joined the jOOQ family including: - DuckDB...

0

7%plop score, above 7 percent of recent articles

Java, SQL and jOOQ.by lukaseder·6 Dec 2023

jOOQ’s DAO API is one of jOOQ’s most controversial features. When it was first implemented, it was implemented merely: - Because it was so easy to implement - Because it seemed so useful for simple...

0

18%plop score, above 18 percent of recent articles

Java, SQL and jOOQ.by lukaseder·28 Jun 2023

Java’s package private visibility is an underrated feature. When you omit any visibility modifier in Java, then the default (for most objects) is package private, i.e.

0

5%plop score, above 5 percent of recent articles

Java, SQL and jOOQ.by lukaseder·25 Apr 2023

Microsoft T-SQL supports a language feature called table-valued parameter (TVP), which is a parameter of a table type that can be passed to a stored procedure or function.

0

2%plop score, above 2 percent of recent articles

Java, SQL and jOOQ.by lukaseder·24 Mar 2023

Occasionally, you want to write a SQL query and fetch a hierarchy of data, whose flat representation may look like this: SELECT id, parent_id, label FROM t_directory; The result might be: |id...

0

4%plop score, above 4 percent of recent articles

Java, SQL and jOOQ.by lukaseder·8 Mar 2023

DiagnosticsListener improvements A lot of additional diagnostics have been added, including the automated detection of pattern replacements, helping you lint your SQL queries irrespective of...

0

6%plop score, above 6 percent of recent articles

Java, SQL and jOOQ.by lukaseder·24 Feb 2023

One of the more frequent questions about jOOQ is how to write a derived table (or a CTE). The jOOQ manual shows a simple example of a derived table: In SQL: SELECT nested.* FROM ( SELECT AUTHOR_ID...

0

15%plop score, above 15 percent of recent articles

Java, SQL and jOOQ.by lukaseder·20 Jan 2023

One of MySQL 8’s biggest improvements is the support of window functions. As I always said in conferences, there’s SQL before window functions and SQL after window functions.

0

9%plop score, above 9 percent of recent articles

Java, SQL and jOOQ.by lukaseder·8 Dec 2022

A frequently encountered doubt people have when using jOOQ is to decide when a “complex” query should be written using jOOQ API vs. when it should be implemented using native SQL.

0

7%plop score, above 7 percent of recent articles