You are correct, direct connection via IPv6 address is not supported - nor is it recommended. In general it is always better to use a hostname, especially when connecting to cloud services like Supabase. Are you able to get a hostname in Supabase by switching to Transaction or Session pooler in their interface?
Yes it working, using this proxied approach is working.
Transaction pooler is using IPv4, and now I’m able to fetch data from my Supabase DB.
Thanks again Sean.