Blog: jooq (Lukas Eder) |
|
210 blogs
updated: 20 min. ago
|
||
|
SQL Server supports transforming flat tabular SQL result sets into hierarchical structures by convention using the convenient FOR XML or FOR...
|
||
|
The SQL MERGE statement is a device whose mystery is only exceeded by its power. A simple example shows its full power according to standard...
|
||
|
One of jOOQ's biggest strength is the fact that it is a type safe SQL API. "Type safe", in this context, means that every object that you pu...
|
||
|
When using jOOQ to create dynamic SQL statements (one of jOOQ's core value propositions), it is often necessary to add query elements condit...
|
||
|
Most jOOQ users use the jOOQ DSL API, which provides compile time type safety and an easy way to write dynamic SQL. But occasionally, this D...
|
||
|
jOOQ supports a vast amount of SQL syntax out of the box. As such, most users will not think of resorting to string concatenation like in th...
|
||
|
It appears that our recent beginner SQL articles explaining SQL syntax were quite popular. These include: A Beginner's Guide to the True Ord...
|
||
|
A very common misconception I often encounter with SQL users is the idea that DISTINCT is something like a function, and that it can take pa...
|
||
|
Starting with jOOQ 3.13, we're offering a new module called jOOQ Refaster, which provides refaster templates for automatic API migration. Wh...
|
||
|
jOOQ 3.13 has been released with CockroachDB support, much more API and tooling for DDL management, and SQL:2011 temporal table support Star...
|
||