Missing index options

[Bilge]

There appears to be no way to set the index order (ASC/DESC) and nulls order (FIRST/LAST). The latter is probably not available in MySQL but is nevertheless part of the SQL standard.

Another major omission is the index access type. In Postgres, this could be heap, btree, hash, gist, gin, spgist or brin. I don't know how portable this is though.

[dereuromark]

Do you want to make a PR here?

[Bilge]

I have no plan presently.

[antoniovj1]

I'm working on adding gin, I'll try to finish the feature during this weekend #2066