they should be compatible, so I don't think you need to see it as an either/or. If you choose to use both however, then you should use drizzle to scaffold your database.
Our clients will work with the drizzle-generated tables (since they use PostgREST).
Or go fully into supabase ecosystems and also use their types and their built in migrations and types