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

Supabase

```
const {data, error} = await supabase
        .from("scholars")
        .select(`
        *,
        daily_slp:scholar_id ( amount,amount_start,amount_end, date )`)
```

```
const {data, error} = await supabase
        .from("scholars")
        .select(`
        *,
        daily_slp:scholar_id ( amount,amount_start,amount_end, date )`)
.eq('daily_slp.amount', '1000')
```

you could do basically any filtering using ur alias you created for the foreign table.