aharpervc opened a new pull request, #1821: URL: https://github.com/apache/datafusion-sqlparser-rs/pull/1821
This PR adds support for declaring cursors on queries for SQL Server ([docs](https://learn.microsoft.com/en-us/sql/t-sql/language-elements/declare-cursor-transact-sql)) Eg, this now parses correctly, which is the "A" example from documentation: ```mssql DECLARE vend_cursor CURSOR FOR SELECT * FROM Purchasing.Vendor OPEN vend_cursor FETCH NEXT FROM vend_cursor; ``` There was already basic support for SQL Server cursors. What was missing was detecting & parsing the `for_query` struct field, and not requiring the `@` prefix for cursor names. A new verified statement test was also added accordingly. -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
