PgAdmin I think is more for working with data, I use Intellij DB editor mostly for writing complex SQL (with autocomplete, coloring, auto-formatting).

It also recognizes your regular programming code strings as SQL and can also autocomplete/highlight typos, but I don't use that, because we're using JOOQ that generates code stubs from live DB.