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

Supabase

In the SQL Editor I can run  on a JSONB column

```
SELECT * FROM messages m WHERE m.sources::text LIKE '%"document": 25%';
```

And works completely fine,

I'm trying to replicate this with the js library
```
 const { data, error } = await supabase
    .from("messages")
    .select(`*`)
    .like("sources", `%"document": ${id}%]`);
```

however unsure how I replicate the ``::text`` as like the SQL query

The purpose of JSONB type in postgres is to be able to query into it. However, the page discussing this on Supabase docs only shows how to select them as output, not filter against them: https://supabase.com/docs/guides/database/json

The answer in this SO question shows you can query into it in the filters: https://stackoverflow.com/questions/68406176/supabase-json-query-javascript

You probably want to filter on `sources->>'document' = 25`

bit difficult as I am trying to reach this:

```
column name: sources

data example:
[{"metadata":{"loc":{"lines":{"to":668,"from":668}},"index":135,"active":true,"chatbots":[2],"document":36}}]
```

So its like sources->>metadata->>document?

You'll want the result of metadata to be a JSON, so `sources->0->metadata->>document`. The ->> gives you a string, and you're inside an array.

```
postgres=> select '[{"metadata":{"loc":{"lines":{"to":668,"from":668}},"index":135,"active":true,"chatbots":[2],"document":36}}]'::jsonb->0->'metadata'->>'document';
 ?column?
----------
 36
(1 row)
```

<@1086143228652306506> worked perfect!!

```
  const { data, error } = await supabase
    .from("messages")
    .select(`*`)
    .eq("sources->0->metadata->>document", String(23));

```