Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I'm trying to query a JSON data but am running into the following issue. Looking at the docs it seems that this should be doable. 
Query:
```
await supabase
    .from<definitions['pass']>('pass')
    .select(
      'id, json',
      {
        count: 'exact',
      }
    )
    .lt('json->expirationDate', new Date(now).toISOString().toLocaleString())
```
Error:
```
{
  message: 'invalid input syntax for type json',
  code: '22P02',
  hint: null,
  details: 'Token "-02" is invalid.'
}
```

What does the data inside of the `json` column look like?

If you are comparing the `json` expirationDate to a string you will probably need double `>` instead.
```js
await supabase
    .from<definitions['pass']>('pass')
    .select(
      'id, json',
      {
        count: 'exact',
      }
    )
    .lt('json->>expirationDate', new Date(now).toISOString().toLocaleString())
```

```
{
  "generic": {
    "backFields": [
      {
        "key": "status",
        "label": "Status",
        "value": "Valid"
      }
    ],
    "headerFields": [],
    "auxiliaryFields": [],
    "secondaryFields": []
  },
  "barcodes": [],
  "logoText": "Logo Test",
  "labelColor": "rgb(69, 74, 117)",
  "formatVersion": 1,
  "expirationDate": "2022-02-15T16:33:28Z",
  "teamIdentifier": "G496R7LJ3Q",
  "backgroundColor": "rgb(255 ,255 , 255)",
  "foregroundColor": "rgb(69, 74, 117)"
}
```

We should probably document that in our docs, but you can find out more about stuff like this from the postgrest website https://postgrest.org/en/v7.0.0/api.html#json-columns

query isn't failing anymore but need to double check the results

What would be the best to check if the fields exists at all?

Since it's value is never set to null, it either exists or doesn't

I would like to think the `.is` filter, but since this field is a from a `jsonb` column, not sure if it will work the same. But you can give it a try

will do. I think using `lt` should cover that case for me

Looks like it's working. Thank you so much!

I'm probably pushing things a bit here but this does not work.

```
.or('json->>expirationDate.is.null', `json->>expirationDate.lt.${new Date(now).toISOString().toLocaleString()}`)
```

my bad, didn't realize the entire input was a single string.

```
.or(`json->>expirationDate.is.null,json->>expirationDate.lt.${new Date(now).toISOString().toLocaleString()}`)

```

It's good that you are experimenting and finding out what works and what doesn't.