Add more documentation after 3.18 release

[lukaseder]

Some of jOOQ 3.18's new features aren't yet sufficiently documented. This includes:

• Add support for PL/SQL TABLE and associative array types in Oracle 18c #5620 (this is being done via blog posts)
  • Possibly other Oracle specific PL/SQL features?
• Add <oracleUseDBAViews/> flag to code generator to use DBA_XYZ views instead of ALL_XYZ views #6311 (won't be documented, as this didn't yield any obviously great results)
• Add Settings.renderTable #8893
  • This has already been added: https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/setting-table-qualification/
• Support logical XOR operator #9720
• Support qualified asterisk on unaliased JoinTables #9743
• Generator strategies should support <schemaExtends/>, <tableExtends/>, <recordExtends/>, <daoExtends/>, <routineExtends/> #9844
• Translate SQL Server WITH (ROWLOCK) clauses to corresponding FOR UPDATE #9880
• Add SQLDialect.category() #10340
• Add a Settings.emulateComputedColumns #13418
• Emulate GROUP BY <column index> using substitution in dialects where this isn't natively supported #13769 Split this into:
  • GROUP BY
  • GROUPING SETS
  • GROUP BY column index
  • Table as GroupField (move this section: https://www.jooq.org/doc/latest/manual/sql-building/table-expressions/tables-as-groupfield/)
• Add support for SQL Server's ALTER VIEW .. AS syntax #14077
  • Best split the DDL section to keep each subsection separate? Also for other DDL statements
• Add ExecuteListener::transformStart and ::transformEnd events #14155 (feature isn't really finished yet)
• Add DSL.raw(String) and Settings.renderPlainSQLTemplatesAsRaw to allow plain SQL without templating #14379
  • It was already done: https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating-raw/
• Add <generatedAnnotationJooqVersion/> option to the code generator #14534

Additional documentation tasks that the above depend on:

• Document Fields::field behaviour in the manual #14676
• GENERATE_SERIES is still undocumented!

---

See also:

• https://www.jooq.org/notes