Exposing Async API

[R1k91]

I’m not sure if this idea makes sense (it does in my head, but I’m open to discussion).

As far as I know, with DAB we can expose stored procedures that may take time to finish. Since it’s a synchronous API, that means I need to keep the connection open until the stored procedure completes.

Wouldn’t it be useful to have the option to flag the API as “async”?
That way, I could support parallelization scenarios (even directly in SQL Server 2025 using sp_invoke_external_rest_endpoint), while letting the database do the work and only polling occasionally for the processing status.

[JerryNixon]

sp_invoke_external_rest_endpoint is also synchronous.

[R1k91]

I didn't get the comment (and the reason to close the idea). The idea is not to have something synchronous but asynchronous.