feat: Add `WithUnsafeStreamResult(true)` Option to `query` service

[kprokopenko]

Feature Request

Describe the Feature Request

Enhance the query service by adding a new option WithUnsafeStreamResult(true). When this option is enabled, the service should return an unmaterialized streamResult. The user must manually close this result. As long as the result is not closed, the session remains occupied.

Additional Context

• Document that the user is responsible for manually closing the returned Result to free up the session.
• Include a warning in the documentation about the potential risks of session leaks if the user fails to close the result properly. The Unsafe in the option name emphasizes the need for caution when using this feature.

[vr-varad]

Hey @kprokopenko I would love to work on this if its open for contribution.

[kprokopenko]

Hey @kprokopenko I would love to work on this if its open for contribution.

Hello!

Contributions are welcome! I will be grateful for any effort.