Spanner supports approximate aggregate functions for both GoogleSQL and PostgreSQL dialects.

Spanner supports automatic parameterization of SQL query literals to improve query performance, reduce latency, and lower CPU costs.

Spanner converts literal values hardcoded in CRUD-style queries, such as primary key lookups, index lookups, and primary key joins, into query parameters, allowing execution plans to be cached and reused to reduce latency and CPU costs.

Spanner queues are generally available (GA).

Spanner queues provide transactional messaging to help you manage asynchronous work. The feature pairs this capability with the scalability and reliability of Spanner, letting you build event-driven applications. For more information, see the Spanner queues overview.

Spanner Graph supports the following enhancements for CREATE PROPERTY GRAPH:

Semantic options for labels and properties: You can configure OPTIONS ( description and synonyms ) on labels and properties to provide context and improve discoverability for natural language querying interfaces.

Spanner supports the following PostgreSQL-dialect database operators:

ILIKE ( ~~* )

Spanner supports using the TABLESAMPLE operator in PostgreSQL-dialect databases to select a random sample of a dataset.

For more information, see TABLESAMPLE operator.