What is new in SQL and the major databases lately (SQL:2023, PostgreSQL 17/18, MySQL 8.4/9.x, SQL Server 2025)?
What is new in SQL and the major databases lately (SQL:2023, PostgreSQL 17/18, MySQL 8.4/9.x, SQL Server 2025)?
SQL keeps evolving. The notes below are the headline changes; check your exact version's release notes before relying on any of them.
GRAPH_TABLE and MATCH patterns. Oracle 23ai supports it; other engines are at different stages.SELECT * FROM GRAPH_TABLE (social
MATCH (a IS person)-[e IS friend]->(b IS person)
WHERE a.name = 'Ann'
COLUMNS (b.name AS friend_name));
ANY_VALUE: standard aggregate for "any row's value" in grouped queries.JSON_TABLE and the SQL/JSON query functions (JSON_EXISTS, JSON_QUERY, JSON_VALUE), MERGE ... RETURNING and WHEN NOT MATCHED BY SOURCE, incremental base backups.uuidv7(), virtual generated columns, OLD and NEW in RETURNING, skip scans for multi-column B-tree indexes, asynchronous I/O for reads, OAuth authentication.Đăng nhập để tham gia thảo luận cùng mọi người.
Chưa có bình luận nào
Hãy là người đầu tiên chia sẻ suy nghĩ của bạn.