hono adapter type override improvment

[elGatoMantocko]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

The withSupabase hono adapter could use some slightly better type ergonomics. As a core feature, Hono supports chaining which compounds the type on the app as a declarative flow. It's not required, but is very useful for things like RPC and using the zod-openapi controller.

If we had a way to override the Database types when invoking withSupabase, the types would be retained through the chained declaration.

Additional context

Maybe "bug" isn't the right context for this, but this feels more like a non-breaking patch bump than a minor version bump.