Support CREATE TABLE inline index specifications

[knutwannheden]

Some dialects support specifying indexes inline in the CREATE TABLE statement. This is currently supported by the parser, but not by the DSL API nor by DSLContext#ddl(), AFAICT.

[lukaseder]

not by the DSL API

We have CreateTableIndexStep. What's missing is a way to create complete Index types (including column specifications), regardless if they're being used with CREATE TABLE or elsewhere.

I was sure we already had an issue for that, but I cannot seem to find it.

nor by DSLContext#ddl(), AFAICT

Is this really needed, separately? I personally prefer if DSLContext#ddl() (now moved to Meta#ddl()) produced separate CREATE INDEX statements, rather than the inline index specification syntax from MySQL.

[lukaseder]

The issue requesting Index type construction DSL is here: #13011

This issue here doesn't request anything that's not yet possible, otherwise. Closing this as a duplicate of #13011