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 generating types using open-api npx command, does anyone have a strategy for managing types when querying foreign tables. I'm currently creating custom for these

I encountered the same issue and did the same as you tbh.
I also looked at other tools to generate typescript types from postgres and they all seem to reach that same conclusion

It seems very hard to understand and generate, even more to make TS Server understand that you're making a join, so none of the ones I found seem to support that nicely...

Yeah that makes sense. I saw in the supabase site that they are building their own tools for generating types. Excited to see how that will work

Thanks for taking the time to respond

Oh I didn't see that actually, that sounds exciting!