Lukas Eder

Support parsing computed columns in CREATE TABLE without type declaration

3

In SQLite, the type is completely ignored (type affinity) when we use `AS` for computed columns. For example, this is valid: ```sql create table t (i int, j geeeenerattteeeeed as...

Support parsing foreign key column definitions without data type

1

In Oracle, it is possible to declare a column without a data type if the data type can be derived from the primary key: ```sql create table par ( c1...

In PostgreSQL, `TIMESTAMP` literals don't have to follow the ISO `YYYY-MM-DD HH24:MI:SS` format. It seems that abbreviated forms are possible as well, e.g. this is `TRUE`: ```sql SELECT TIMESTAMP '2000-01-01'...

Transform Teradata style SELECT alias references

2

Teradata bends the rules of the logical order of SQL operations quite a bit, see: https://blog.jooq.org/a-beginners-guide-to-the-true-order-of-sql-operations/ In Teradata, it seems that these are possible: **Referencing column alias from `WHERE`**: ```java...

Starting from jOOQ 3.17 and https://github.com/jOOQ/jOOQ/issues/4727, we support projecting table expressions in `SELECT` in all dialects, with some native support in PostgreSQL. From an API point of view, it is...

jOOQ 3.18 introduces emulation support for `GROUP BY ` using substitution via https://github.com/jOOQ/jOOQ/issues/13769 E.g. ```sql SELECT first_name || ' ' || last_name AS name FROM actor GROUP BY 1 ORDER...

PostgreSQL 15 has some useful extension to the standard SQL `MERGE` statement: It is possible in both types of `WHEN` clauses to append a `DO NOTHING` clause instead of the...

Add API to bind named parameters to plain SQL QueryParts

6

The following test fails: ```java @Test public void testPlainSQLParamRenderingRepeatedParams() { ResultQuery q1 = resultQuery( "select :first as a1, coalesce(:second, :second) as b1, :second as b2, :first as a2", param("first", 1),...

SQL:2011 has introduced a much overlooked but cool feature called "nested window functions", see ISO/IEC 9075-2:2016(E) 6.11 <nested window function>. So far, I haven't seen any implementations of it in...

In 12c, recursive subquery factoring (CTE, WITH clause) has received a new feature specifying how the recursive search should handle cycles:  https://docs.oracle.com/database/121/SQLRF/img_text/cycle_clause.htm