Querio 0.1.0
dotnet add package Querio --version 0.1.0
NuGet\Install-Package Querio -Version 0.1.0
<PackageReference Include="Querio" Version="0.1.0" />
<PackageVersion Include="Querio" Version="0.1.0" />
<PackageReference Include="Querio" />
paket add Querio --version 0.1.0
#r "nuget: Querio, 0.1.0"
#:package Querio@0.1.0
#addin nuget:?package=Querio&version=0.1.0
#tool nuget:?package=Querio&version=0.1.0
Querio
The core: a schema, a serializable query, a fluent builder, a validator, and the shared walk every target renders through. It builds queries and never runs them.
var spec = QueryBuilder.From(schema, "requests", "r")
.Select("r", "route")
.CountRows("total")
.Where(f => f.Since("r", "timestamp", 30, QueryTimeUnit.Day))
.GroupBy("r", "route")
.OrderBySelectDescending("total")
.Build();
What comes out is a plain object. Add a target package to turn it into something:
Querio.Sql |
SQL Server, PostgreSQL, SQLite |
Querio.OneC |
the 1C query language |
Querio.Linq |
expression trees for EF Core, or execution over objects |
Querio.Http |
a query string, both directions |
Querio.Text |
a sentence, both directions |
Querio.Language |
SQL-shaped text with foreign-key navigation |
No dependencies. This package references only the base class library.
Values travel as data and are parameterised by the renderer, so nothing is ever spliced into a query. Names are logical, so the same saved query survives a rename in storage. A target declares what it cannot express and fails loudly instead of approximating.
Targets netstandard2.0, net8.0, net9.0, net10.0.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- No dependencies.
-
net10.0
- No dependencies.
-
net8.0
- No dependencies.
-
net9.0
- No dependencies.
NuGet packages (7)
Showing the top 5 NuGet packages that depend on Querio:
| Package | Downloads |
|---|---|
|
Flare.Components.Query
A visual query designer for Flare, built on the Querio query model. Composes joins, aggregates, grouping, conditions and paging over a caller-supplied schema, and emits a serializable query spec that the consumer renders or executes however it likes. |
|
|
Querio.Language
Reads and writes Querio queries as SQL-shaped text, with foreign-key navigation and completion candidates for an editor. Reports every problem it finds with a position, rather than stopping at the first. |
|
|
Querio.OneC
Renders a Querio query into the 1C:Enterprise query language, with parameters rather than inlined values. Declares the narrower capability set 1C has, so a query asking for a row offset or a percentile is refused instead of quietly answering something else. |
|
|
Querio.Sql
Renders a Querio query into parameterized SQL. Ships dialects for SQL Server, PostgreSQL and SQLite, each declaring what it can and cannot do so an unsupported query fails loudly instead of silently answering a different question. |
|
|
Querio.Linq
Executes a Querio query as .NET code. Builds expression trees rather than query text, so a saved query can filter an IQueryable through any LINQ provider or run directly over in-memory objects. |
GitHub repositories
This package is not used by any popular GitHub repositories.