Postgres Support

[shishkin]

I'm looking forward to this project to support Postgres dialect, so it can unblock Postgres support in the prettier plugin.

Edit: I'm hijacking this issue to track the overall progress of PostgreSQL support:

• Postgres support (basic syntax) #42
  • Mostly done, some quirky edge-cases remaining, like allowing some reserved keywords as implicit aliases.
• Postgres support (operators) #49
  • Mostly done, some quirky edge-cases remaining, like full support for custom operators and the elaborate type casting syntax.
• Postgres support (custom operators) #96
  • Nothing yet.
• Postgres support (special functions syntax) #97
  • Nothing yet.
• Postgres support (data types) #46
• Postgres support (queries) #44
• Postgres support (DML) #47
• Postgres support (create table) #48
• Postgres support (alter/drop table) #57
• Postgres support (indexes) #58
• Postgres support (functions) #63
• Postgres support (views) #64
• Postgres support (schemas) #65
• Postgres support (sequences) #66
• Postgres support (triggers) #67
  • CREATE/ALTER/DROP TRIGGER fully supported, EVENT TRIGGER support missing.
• Postgres support (users, roles, groups) #73
• Postgres support (user defined types) #78
  • Full support for domains, common cases for CREATE TYPE covered.
• Postgres support (extensions) #94
  • Missing ALTER EXTENSION support.
• Postgres support (transactions) #99
• Postgres support (Cursors) #98
  • Nothing yet.
• Postgres support (policies) #103
• Postgres support (COMMENT) #105
  • Almost all (except comments on operators and aggregate functions)
• Postgres support (prepared statements) #113
• Postgres support (configuration parameters) #114
• PostgreSQL support (publications & subscriptions) #117
  • Missing ALTER SUBSCRIPTION support.
• Postgres support (foreign servers) #118
  • CREATE/ALTER/DROP FOREIGN TABLE supported. Nothing else.
• Postgres support (other statements) #43
  • I have barely started even mapping out the work that remains.

For reference: gram.y in Postgres Github repository.

[karlhorky]

Would also love to see PostgreSQL support here 🙌 @nene is this something on the mid-term roadmap?

[nene]

Well, it is sort of on the roadmap since starting working on this whole library. But Postgres being pretty big and complex, just the thought of the task ahead puts me off from starting to implement support for it.

[karlhorky]

Understood, thanks for the reply. Really appreciate the work that you're doing on both this project and sql-formatter.

I guess there's also not a way to build on existing parsers / existing schema data or use code generation somehow to reduce the implementation complexity here... 🤔

[wolfgangwalther]

To fully support postgres, it would be good to support psql meta commands (starting with \) and variables (with :), too.

[nene]

To fully support postgres, it would be good to support psql meta commands (starting with ) and variables (with :), too.

Yep. This is in the plans. But for now I'm concentrating on finishing the support for the actual SQL part.

Another thing to fully support Postgres is having support for PL/pgSQL.

I think both can be implemented as supersets of the base PostgreSQL grammar.