Completions for PostgreSQL GIN/GiST/SP-GiST/BRIN Indices

[pimeys]

We'll be introducing new index types for PostgreSQL. The catch here is all of them either require or allow you to define the operator classes per indexed field. For example:

model A {
  id  Int    @id
  val String @db.Inet

  @@index(val(ops: InetOps), type: Gist)
}

The language server should offer proper auto-completion items here:

model A {
  id  Int    @id
  val String @db.Inet

  @@index(val(ops: |), type: Gist)
//                 ^ See the native type of `val` is `Inet` and
//                   the index type is GiST, offer `InetOps`.
}

and here:

model A {
  id  Int    @id
  val String @db.Inet

  @@index(val(ops: InetOps), type: |)
//                                 ^ offer Gist, Gin, SpGist, Brin, Hash or BTree
}

Rules:

• The operator class must match the native type and the index type (see the lists here)
• The extendedIndexes preview feature must be on
• Provider must be postgresql