>multigres from supabase seems promising

I have high hopes for Neki from Planetscale but then again if you are not stuck on Postgres for whatever reason, Vitess with MySQL is about as battle tested as it gets.