Query handling and filtering of array fields - `(where: {name: {_any: "admin"}})`

[bendog]

The Scenario. We have names stored in varchar[] arrays in the table, this is to help with multi-language deployments and was designed some time ago, hence not jsonb.

group_table {
  id
  name
}

will return

[
  {
    "id": 1,
    "name": [
      "admin",
      "admin_but_other_langage"
    ]
  },
  ...etc...
]

The Desired behaviour. it would be useful to be able to define which array entry you wish to return

group_table {
  id
  name[0]
}

it would also be very helpful to be able to filter on these

group_table (where: {name: {_any: "admin"}} {
  id
  name
}

or

group_table (where: {name[0]: {_eq: "admin"}} {
  id
  name
}

thanks for all the great work.

[rikinsk-zz]

relevent to: #1767/#1799