Support for filtering JSONB column

[noobmaster19]

What would you like to be added: The ability to filter by a JSONB column without creating a virtual table.

The usage could potentially be:

query getQuotations {
  quotation(
    where: {validity_period: {issue_date: {lte: "2024-09-18T03:03:16+0000"}}}
  ) {
    validity_period
  }
}

Or

query getQuotations {
  quotation(
    where: {validity_period->>issue_date: {lte: "2024-09-18T03:03:16+0000"}}
  ) {
    validity_period
  }
}

Why is this needed: It is quite common that people store data using JSONB, without an "ID" column to relate the data above (Therefore cannot use virtual columns as there's no identifier linking both together.

[awgneo]

I would love this feature as well :) Having to define configuration for JSONB fields sort of defeats the purpose of auto-discovery just working out of the box.

[dosco]

Cool, I'll take a look