drizzle orm v1 & relations v2 support

[adamkasper]

related: nuxt-hub/core#825
related: better-auth/better-auth#6913

[onmax]

Mmmm, not sure if you expect to update something int his library? we just consume nuxthub and better-auth, I think once they release their version we will update the dependency and should work :)

keeping it open, and feel free to ping me when they release the new version to test the feature and close the issue

[adamkasper]

I think the only change needed is here:

better-auth/src/module/templates.ts

Line 28 in ce8f001

import { drizzleAdapter } from 'better-auth/adapters/drizzle'

it should now use @better-auth/drizzle-adapter/relations-v2 according to their latest updates