I think the problem is this won't work

I think maybe I need to do something else, but this is my first time using postgres

It's a jsonb column

Not sure if that would work

Let me try and get some SQL for you to set this up in a way you can get all the data you need from the one query

What is the name of this table you have taken a screenshot of?

sql
CREATE TABLE public.comments (
    id uuid primary key default uuid_generate_v4(),
    data text,
    inserted_at timestamp with time zone default now() not null,
    updated_at timestamp with time zone,
    author uuid references public.profiles not null,
    post int8,
    karma int4
)

CREATE TABLE public.replies (
    id uuid primary key default uuid_generate_v4(),
    author uuid references public.profiles not null,
    message text,
    comment_id uuid references public.comments not null,
    inserted_at timestamp with time zone default now() not null,
    updated_at timestamp with time zone
)

The assumption in here is that your reference to the author is to a table in your public schema called

profiles

, maybe your setup is not using that table so change that accordingly. With this you don't store replies inside a jsonb column as a reference to the original comment is stored in the replies table., now you should be able to run your JS code and get results

js
const { data } = await supabase
    .from("comments")
    .select(
        `id, inserted_at, data, karma, 
        author( id, username ), 
        replies(
            message,
            author ( username:reply_username )
        )
    `)
    .order("inserted_at", { ascending: false })
    .eq("post", query.id);

I haven't tested the JS part of this code but it should work

Will that work with replies to replies?