Does SurrealDB 2.0 preserve the SELECT syntax used in version 1.x?
0 reputation · 11 Feb 2025, 00:26 UTC
When planning an upgrade from SurrealDB 1.x to 2.0, the goal is to verify that existing SELECT queries continue to execute without modification.
The SurrealDB changelog notes that major releases sometimes alter SELECT clause syntax, but the documentation does not explicitly list which clauses are affected or provide a migration path. This uncertainty raises the risk of silent query failures in production.
Does SurrealDB 2.0 retain the same semantics for SELECT … FETCH, SPLIT, and GROUP BY clauses as 1.x? Which SELECT clauses have been identified as breaking changes in the release notes? Is there a published compatibility matrix or test suite that confirms SELECT syntax stability across these versions?