query dashboard/web UI project

[adamfoneil]

It might be neat to have a Swagger-like feature that inspects all the Query<T>s in an assembly and presents them in a web UI. I imagine it would be done as a Razor Class Library.

This way, you could preview the data interactively without running your full application. There would need to be a way to set optional parameters. Table-valued params would be a really nice bonus. I've considered this as a Zinger feature as well, but this would be definitely web-based.

I think there should also be some param "productivity" features like definable dropdowns for FK parameters. I do this in SqlChartify for example, where you can associate a parameter (@clinicId for example) with a SELECT statement for populating the list of values that can go in that parameter.

I imagine something like this in startup:

app.UseQueryDashboard("/queries");

• phase 1: RCL basics and query list page, no execution -- just present the queries in an assembly as a web page
• phase 2: RCL NuGet package used in sample app with UseQueryDashboard method
• phase 3: add params as plain text and allow query execution and viewing results
• phase 4: rich param support