The complete feature comparison is here: https://www.sql-workbench.eu/dbms_comparison.html https://www.sql-workbench.eu/dbms_comparison.html Range types, array

The complete feature comparison is here: https://www.sql-workbench.eu/dbms_comparison.html https://www.sql-workbench.eu/dbms_comparison.html Range types, array types, foreign table wrappers, partial indexes, statement-level triggers, MERGE, non-blocking index creation, row-level security, etc. And that all isn't counting the huge ecosystem of extensions and custom functions & types for Postgres. It still boggles my mind that in 2023, MySQL STILL cannot use a temporary table in a query more than once [0]. [0]: https://stackoverflow.com/questions/9364602/how-can-i-refer-to-a-temporary-table-more-than-once-in-the-same-query https://stackoverflow.com/questions/9364602/how-can-i-refer-...