The Supabase team is actively developing (and ready for collaborators on) a language server (LSP) for Postgres.

They say it's "Not SQL with flavors, just Postgres."

🔗 https://github.com/supabase/postgres_lsp