[Feature request]: Generate Kotlin types from Database

[iruizmar]

General Info

• I installed the latest version of Supabase Kt
• I checked for similar feature requests

Feature request

This is a feature present in typescript SDK and it's so useful.
We could use KSP for this.

Usecase

No response

[jan-tennert]

So I think calling the API for every build/sync is not a good idea. So maybe we have a separate command/gradle task for retrieving the database types and saving them in a file (JSON or some other file format). Then on the normal builds, the ksp annotation processor reads this data and generates these classes. This would also solve compatibility issues, where database changes are not yet present in the app.

[grdsdev]

I added type generation for Swift a couple of weeks ago, still in beta, supabase/postgres-meta#779 and it isn't as powerful as typescript types, for now, it just generates a plain Swift struct that mimics the DB schema.

[jan-tennert]

I added type generation for Swift a couple of weeks ago, still in beta, supabase/postgres-meta#779 and it isn't as powerful as typescript types, for now, it just generates a plain Swift struct that mimics the DB schema.

Yea, I asked about that on Slack, so I'll look into that too.