Lukas Eder
@lukaseder.bsky.social
Java Champion, creator of jOOQ, the best way to write SQL in Java.
Will mostly post about Java, SQL, jOOQ, programming humour, and write at https://blog.jooq.org
Will mostly post about Java, SQL, jOOQ, programming humour, and write at https://blog.jooq.org
Pinned
Reposted by Lukas Eder
LEAD(x) IGNORE NULLS OVER(ORDER BY n)
Not very often, but when I need IGNORE NULLS, then I really miss it in PostgreSQL.
modern-sql.com/caniuse/T616
Not very often, but when I need IGNORE NULLS, then I really miss it in PostgreSQL.
modern-sql.com/caniuse/T616
T616, “Null treatment option for LEAD and LAG functions”
T616, “Null treatment option for LEAD and LAG functions” in SQL
modern-sql.com
January 22, 2026 at 12:47 PM
LEAD(x) IGNORE NULLS OVER(ORDER BY n)
Not very often, but when I need IGNORE NULLS, then I really miss it in PostgreSQL.
modern-sql.com/caniuse/T616
Not very often, but when I need IGNORE NULLS, then I really miss it in PostgreSQL.
modern-sql.com/caniuse/T616
Reposted by Lukas Eder
The love/hate Hibernate topic hasn't lost it's relevance: the video sparkled a nice conversation on Reddit www.reddit.com/r/java/comme...
What is your stance, friends? What do you prefer, ORM or JDBC/jOOQ?
What is your stance, friends? What do you prefer, ORM or JDBC/jOOQ?
👾New on CyberJAR: Hibernate, Ditch or Double Down?
What Hibernate does under the hood, in which scenarios it shines, how you can fall into a trap, and when SQL-first approach is better?
And can you have the best of two worlds in one #Java app?
Watch and find out ->
www.youtube.com/watch?v=J12v...
What Hibernate does under the hood, in which scenarios it shines, how you can fall into a trap, and when SQL-first approach is better?
And can you have the best of two worlds in one #Java app?
Watch and find out ->
www.youtube.com/watch?v=J12v...
Hibernate: Ditch or Double Down? When ORM Isn't Enough
YouTube video by CyberJAR
www.youtube.com
January 14, 2026 at 1:22 PM
The love/hate Hibernate topic hasn't lost it's relevance: the video sparkled a nice conversation on Reddit www.reddit.com/r/java/comme...
What is your stance, friends? What do you prefer, ORM or JDBC/jOOQ?
What is your stance, friends? What do you prefer, ORM or JDBC/jOOQ?
This little API change allows for omitting some syntactic ceremony when working with EXISTS subqueries in jOOQ:
github.com/jOOQ/jOOQ/is...
E.g. you can now write:
ctx. select(AUTHOR, exists(AUTHOR. book()))
.from(AUTHOR)
Instead of spelling out the complete correlated subquery.
github.com/jOOQ/jOOQ/is...
E.g. you can now write:
ctx. select(AUTHOR, exists(AUTHOR. book()))
.from(AUTHOR)
Instead of spelling out the complete correlated subquery.
Change exists(Select<?>) to exists(TableLike<?>) for convenience · Issue #19568 · jOOQ/jOOQ
When checking for existence of records in a table, it could be convenient to be able to write exists(MY_TABLE) instead of exists(selectOne().from(MY_TABLE)). This is especially true when working wi...
github.com
January 7, 2026 at 4:13 PM
This little API change allows for omitting some syntactic ceremony when working with EXISTS subqueries in jOOQ:
github.com/jOOQ/jOOQ/is...
E.g. you can now write:
ctx. select(AUTHOR, exists(AUTHOR. book()))
.from(AUTHOR)
Instead of spelling out the complete correlated subquery.
github.com/jOOQ/jOOQ/is...
E.g. you can now write:
ctx. select(AUTHOR, exists(AUTHOR. book()))
.from(AUTHOR)
Instead of spelling out the complete correlated subquery.
Reposted by Lukas Eder
One Query, Complete Object Graphs: Nested DTOs with jOOQ MULTISET martinelli.ch/one-query-co... by @martinelli.ch
One Query, Complete Object Graphs: Nested DTOs with jOOQ MULTISET - Martinelli
In my previous post about Open Session in View, I explored how this default Spring Boot setting can hide serious performance problems. The N+1 query problem sits behind a system that looks correct in ...
martinelli.ch
January 5, 2026 at 2:02 PM
One Query, Complete Object Graphs: Nested DTOs with jOOQ MULTISET martinelli.ch/one-query-co... by @martinelli.ch
“There are only two tragedies in life: one is not getting what one wants, and the other is getting it.”
― Oscar Wilde
― Oscar Wilde
December 15, 2025 at 9:39 AM
“There are only two tragedies in life: one is not getting what one wants, and the other is getting it.”
― Oscar Wilde
― Oscar Wilde
My disappointment when SQL dialects choose this kind of name resolution strategy is very very deep
November 25, 2025 at 12:28 PM
My disappointment when SQL dialects choose this kind of name resolution strategy is very very deep
Man, I've been doing jOOQ for 15+ years now and I still write flaky tests due to missing ORDER BY clauses, and thus non-deterministic result set ordering 🫠
November 25, 2025 at 12:03 PM
Man, I've been doing jOOQ for 15+ years now and I still write flaky tests due to missing ORDER BY clauses, and thus non-deterministic result set ordering 🫠
Reposted by Lukas Eder
🇫🇷 jOOQ et le code legacy:
1/ https://shodo.io/jooq-et-le-code-legacy-1/
2/ https://shodo.io/jooq-et-le-code-legacy-2/
1/ https://shodo.io/jooq-et-le-code-legacy-1/
2/ https://shodo.io/jooq-et-le-code-legacy-2/
November 20, 2025 at 8:02 AM
🇫🇷 jOOQ et le code legacy:
1/ https://shodo.io/jooq-et-le-code-legacy-1/
2/ https://shodo.io/jooq-et-le-code-legacy-2/
1/ https://shodo.io/jooq-et-le-code-legacy-1/
2/ https://shodo.io/jooq-et-le-code-legacy-2/
Huh, has Oracle stopped publishing commits to the MySQL github repo?
github.com/mysql/mysql-...
github.com/mysql/mysql-...
github.com/mysql/mysql-...
github.com/mysql/mysql-...
Commits · mysql/mysql-server
MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-time, open source transactional database. - Commits · mysql/mysql-server
github.com
November 24, 2025 at 7:34 AM
Huh, has Oracle stopped publishing commits to the MySQL github repo?
github.com/mysql/mysql-...
github.com/mysql/mysql-...
github.com/mysql/mysql-...
github.com/mysql/mysql-...
🤯
Coming in Oracle AI Database
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS ( )
)
@toonkoppelaars.bsky.social explains at #DOAG2025
#SQL assertions
These enable you to create cross row, cross table constraints with SQL standard syntax
CREATE ASSERTION … CHECK (
[ NOT ] EXISTS (
)
@toonkoppelaars.bsky.social explains at #DOAG2025
November 19, 2025 at 1:20 PM
🤯
Fun discovery, the standard SQL aggregate FILTER clause can be emulated with Google SQL's (BigQuery, Spanner) aggregate HAVING clause.
This is especially useful when the default emulation using CASE doesn't work as NULL values should be preserved, e.g. in ARRAY_AGG()
github.com/jOOQ/jOOQ/is...
This is especially useful when the default emulation using CASE doesn't work as NULL values should be preserved, e.g. in ARRAY_AGG()
github.com/jOOQ/jOOQ/is...
November 18, 2025 at 10:38 AM
Fun discovery, the standard SQL aggregate FILTER clause can be emulated with Google SQL's (BigQuery, Spanner) aggregate HAVING clause.
This is especially useful when the default emulation using CASE doesn't work as NULL values should be preserved, e.g. in ARRAY_AGG()
github.com/jOOQ/jOOQ/is...
This is especially useful when the default emulation using CASE doesn't work as NULL values should be preserved, e.g. in ARRAY_AGG()
github.com/jOOQ/jOOQ/is...
Due to the Liquibase license change to the FSL, I've deprecated the LiquibaseDatabase, which is used for jOOQ code generation:
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
Deprecate LiquibaseDatabase · Issue #19353 · jOOQ/jOOQ
The LiquibaseDatabase includes a liquibase dependency on version 4.x of Liquibase: https://www.jooq.org/doc/latest/manual/code-generation/codegen-meta-sources/codegen-liquibase/ This issue has show...
github.com
November 10, 2025 at 1:31 PM
Due to the Liquibase license change to the FSL, I've deprecated the LiquibaseDatabase, which is used for jOOQ code generation:
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
github.com/jOOQ/jOOQ/is...
Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...
Some RDBMS have a weird understanding of case sensitivity in identifiers.
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
November 6, 2025 at 3:20 PM
Some RDBMS have a weird understanding of case sensitivity in identifiers.
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
Here's Google Spanner.
- Quoting doesn't affect case sensitivity
- DDL identifiers are case sensitive (though "duplicates" are not allowed)
- DML identifiers are not case sensitive
Reposted by Lukas Eder
This is... something:
aws.amazon.com/de/blogs/big...
aws.amazon.com/de/blogs/big...
Amazon Redshift Python user-defined functions will reach end of support after June 30, 2026 | Amazon Web Services
The Amazon Redshift integration with AWS Lambda provides the capability to create Amazon Redshift Lambda user-defined functions (UDFs). Because Lambda UDFs provide these significant advantages in inte...
aws.amazon.com
October 30, 2025 at 1:16 PM
This is... something:
aws.amazon.com/de/blogs/big...
aws.amazon.com/de/blogs/big...
What do you folks think? Is this a good email footer?
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
October 29, 2025 at 12:53 PM
What do you folks think? Is this a good email footer?
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
“The bureaucracy is expanding to meet the needs of the expanding bureaucracy.”
― Oscar Wilde
What on earth is AWS Clean Rooms SQL??
docs.aws.amazon.com/clean-rooms/...
docs.aws.amazon.com/clean-rooms/...
Overview of SQL in AWS Clean Rooms - AWS Clean Rooms
Learn about the types of SQL functions you can use in AWS Clean Rooms.
docs.aws.amazon.com
October 29, 2025 at 8:49 AM
What on earth is AWS Clean Rooms SQL??
docs.aws.amazon.com/clean-rooms/...
docs.aws.amazon.com/clean-rooms/...
Recursive generics are so tricky to grasp because they rely on grasping recursive generics.
October 23, 2025 at 12:18 PM
Recursive generics are so tricky to grasp because they rely on grasping recursive generics.
Did we as an industry just collectively agree that "bouncy castle" is a very secure sounding term for a "security provider," yes?
downloads.bouncycastle.org/java/docs/bc...
downloads.bouncycastle.org/java/docs/bc...
BouncyCastleProvider (Bouncy Castle Library 1.81 API Specification)
downloads.bouncycastle.org
October 20, 2025 at 1:11 PM
Did we as an industry just collectively agree that "bouncy castle" is a very secure sounding term for a "security provider," yes?
downloads.bouncycastle.org/java/docs/bc...
downloads.bouncycastle.org/java/docs/bc...
So, we now have:
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
October 20, 2025 at 12:13 PM
So, we now have:
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
- BigQuery
- ClickHouse
- Databricks
- DuckDB
- Exasol
- H2
- Snowflake
- Teradata (the inventor, I think?)
And now also:
- Oracle!
I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?
Reposted by Lukas Eder
Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
October 20, 2025 at 11:02 AM
Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
This adds the QUALIFY clause
QUALIFY filters window functions after grouping
Like the HAVING clause does for aggregate functions
SELECT ... FROM ...
QUALIFY fn OVER ( ... ) > ...
Well, that's something! The Derby Database is unsupported ("retired"). It has been around forever, I'm kinda feeling nostalgic about this...
issues.apache.org/jira/browse/...
issues.apache.org/jira/browse/...
[DERBY-7177] Retire Derby - ASF JIRA
issues.apache.org
October 16, 2025 at 8:52 AM
Well, that's something! The Derby Database is unsupported ("retired"). It has been around forever, I'm kinda feeling nostalgic about this...
issues.apache.org/jira/browse/...
issues.apache.org/jira/browse/...
Q: Does your RDBMS use zero-based or one-based indexing?
A: Yes
A: Yes
October 10, 2025 at 12:31 PM
Q: Does your RDBMS use zero-based or one-based indexing?
A: Yes
A: Yes
Reposted by Lukas Eder
Are you making any of these common #SQL mistakes?
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more
10 Common Mistakes Java Developers Make when Writing SQL
This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java develop…
buff.ly
October 8, 2025 at 11:02 AM
Are you making any of these common #SQL mistakes?
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more
Forgetting about NULL
Processing data in Java memory
Using JDBC Pagination to paginate large results
Using aggregate instead of window functions
@lukaseder.bsky.social explains what to do instead & lists 7 more