Lukas Eder
Lukas Eder
Formerly known as Presto (https://github.com/jOOQ/jOOQ/issues/5414), now Trino: https://trino.io/blog/2020/12/27/announcing-trino.html
Vertica supports a factorial operator: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Operators/MathematicalOperators.htm It can be emulated with a recursive query: ```sql WITH RECURSIVE t (n, p) AS ( SELECT 2, 2 UNION ALL SELECT n +...
Starting from jOOQ 3.15, we support comparing `MULTISET` values by comparing their `JSON(B)` or `XML` contents. Comparing XML isn't really supported in most RDBMS, because the default semantics isn't clear...
jOOQ 3.16 introduces support for standard SQL and PG14 `GROUP BY DISTINCT` (see https://github.com/jOOQ/jOOQ/issues/11670). This would be a nice feature to emulate elsewhere, along with `GROUPING SETS`: https://github.com/jOOQ/jOOQ/issues/11669
Following up on https://github.com/jOOQ/jOOQ/issues/11834, where `Table
A [CrateDB](https://crate.io/) dialect has been requested occasionally, recently (see links below). It is not a very popular database product, see https://db-engines.com/en/ranking, but perhaps, someone is interested in sponsoring the integration....
Standard SQL, as well as at least these three RDBMS support an `OVERRIDING { SYSTEM | USER } VALUE` syntax to allow for specifying what should happen when a (bulk)...
After the upgrade of our code to `org.jetbrains:annotations:23.0.0` (see https://github.com/jOOQ/jOOQ/issues/12874), and once all blocking operations are annotated using `org.jetbrains.annotations.Blocking` (see https://github.com/jOOQ/jOOQ/issues/12875), we could offer a static compile-time checker in the...
SQLite 3.35 supports a "generalised" `ON CONFLICT` clause, i.e. there can be multiple `ON CONFLICT` clauses now: https://www.sqlite.org/lang_upsert.html For example, this works: ```sql create table t ( i int primary...
Some scopes are nested, meaning that a `ChildScope` is created in the context of a parent scope. It usually shares the parent scope's `Scope::data` map. Exposing this relationship could be...