Since we're here talking about Postgres and SQL standards. Here's my wishlist:
- Support for arrays of foreign keys. This one has been worked on a couple of times but hasn't made it into a release. https://commitfest.postgresql.org/17/1252/ - I think this would be an absolutely phenomenal way of handling sorting, instead of having to use linked lists and CTEs or some type of "order/position" column
- Support for deferring NOT NULL and CHECK constraints to the end of a transaction (just ran into this problem yesterday)
- Support for arrays of foreign keys. This one has been worked on a couple of times but hasn't made it into a release. https://commitfest.postgresql.org/17/1252/ - I think this would be an absolutely phenomenal way of handling sorting, instead of having to use linked lists and CTEs or some type of "order/position" column
- Support for deferring NOT NULL and CHECK constraints to the end of a transaction (just ran into this problem yesterday)
Edit: typos