Asserting EF Core query counts in integration tests — catching N+1 regressions

[KiwiDevelopment]

Steve, you've written a lot about testing best practices in Clean Architecture. One pattern I haven't seen discussed much in the .NET world is asserting the number of SQL queries an endpoint fires — not just the result.
Django has had assertNumQueries built-in since 2011. In .NET there's no equivalent, so every team either ignores it or writes their own DbCommandInterceptor boilerplate.
I built KiwiQuery.EFCore to fill that gap:

  await using var guard = factory.TrackQueries<Program, AppDbContext>();
  var client = guard.CreateClient();

  await client.GetAsync("/api/items");

  guard.AssertCount(exact: 1);

The idea: add one assertion per critical endpoint, and N+1 regressions get caught in CI before they hit production.
Repo: https://github.com/KiwiDevelopment/KiwiQuery, NuGet: KiwiQuery.EFCore. MIT, one dependency.

Do you think this pattern deserves a place in Clean Architecture templates? Curious to hear your take.