There's now a new interface on IAdvancedSql that wraps all advanced sql query methods and adds new methods to stream the results via IAsyncEnumrable.
The old AdvancedSql*-methods are marked as obsolete and delegate to the new methods.
The new AdavancedSql methods are implemented as explicit interface implementations on the QuerySession class as a separate partial class. The alternative would be to make IQuerySession.Advanced return a separate implementation of IAdvancedSql. Let me know, if you prefer this and I will change the PR.
There's now a new interface on IAdvancedSql that wraps all advanced sql query methods and adds new methods to stream the results via IAsyncEnumrable.
The old AdvancedSql*-methods are marked as obsolete and delegate to the new methods.
The new AdavancedSql methods are implemented as explicit interface implementations on the QuerySession class as a separate partial class. The alternative would be to make IQuerySession.Advanced return a separate implementation of IAdvancedSql. Let me know, if you prefer this and I will change the PR.