JamesVorder opened a new pull request, #2155: URL: https://github.com/apache/datafusion-sqlparser-rs/pull/2155
This PR adds support for Databricks' version-based [time travel](https://docs.databricks.com/aws/en/delta/history#delta-time-travel-syntax). This is a next step toward resolving https://github.com/apache/datafusion-sqlparser-rs/issues/2006, following https://github.com/apache/datafusion-sqlparser-rs/pull/2134. The following is now supported: ```sql SELECT 1 FROM t1 VERSION AS OF 10; ``` **Note:** This PR makes a couple opinionated changes: * When parsing a version to time-travel to, only scalar values are allowed. This is consistent with the limitations of Databricks. None of the other target query engines support time travel by version. * I've made the assumption that we want to parse `VERSION AS OF` syntax for all dialects that support time travel, regardless of downstream support for that syntax. (Consistent with guidance given [here](https://github.com/apache/datafusion-sqlparser-rs/pull/2134#discussion_r2631929918).) * I've refactored `supports_timestamp_versioning` --> `supports_table_versioning`, since we now support table versioning by something other than a timestamp. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
