krlmlr commented on issue #61: URL: https://github.com/apache/arrow-adbc/issues/61#issuecomment-1214423568
Last inserted IDs (or the results of computed columns in general, for that matter) can be obtained with the `RETURNING` syntax for most databases, SQL Server has `OUTPUT` . This seems far more robust to me than a "last inserted ID". R DBI has `dbGetQuery()` and `dbExecute()` as methods that are sufficient for most users, and `dbSendQuery()` + `dbBind()` + `dbFetch()` + `dbClearResult()` or `dbSendStatement()` + `dbBind()` + `dbClearResult()` . If ADBC is to remain header-only, what would a convenience method look like? -- 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]
