Quarry.Analyzers 0.1.0

dotnet add package Quarry.Analyzers --version 0.1.0

NuGet\Install-Package Quarry.Analyzers -Version 0.1.0

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Quarry.Analyzers" Version="0.1.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Quarry.Analyzers" Version="0.1.0" />
                    

                            Directory.Packages.props

<PackageReference Include="Quarry.Analyzers" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add Quarry.Analyzers --version 0.1.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Quarry.Analyzers, 0.1.0"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#:package Quarry.Analyzers@0.1.0

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=Quarry.Analyzers&version=0.1.0
                    

                            Install as a Cake Addin

#tool nuget:?package=Quarry.Analyzers&version=0.1.0
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Quarry

Type-safe SQL builder for .NET 10. Source generators + C# 12 interceptors emit all SQL at compile time. AOT compatible. Structured logging via Logsmith.

Quarry.Analyzers

Compile-time SQL query analysis rules for Quarry. 18 Roslyn diagnostics detect performance issues, wasteful patterns, and dialect-specific problems in Quarry query call sites.

Packages

Name	NuGet	Description
`Quarry`		Runtime types: builders, schema DSL, dialects, executors.
`Quarry.Generator`		Roslyn incremental source generator + interceptor emitter.
`Quarry.Analyzers`		Compile-time SQL query analysis rules (QRA series) with code fixes.
`Quarry.Analyzers.CodeFixes`		Code fix providers for QRA diagnostics.
`Quarry.Tool`		CLI tool for migrations and database scaffolding (`quarry` command).

Installation

<PackageReference Include="Quarry.Analyzers" Version="1.0.0"
    OutputItemType="Analyzer"
    ReferenceOutputAssembly="false" />

Requires Quarry and Quarry.Generator to be referenced in the same project.

Diagnostic Rules

All rules are enabled by default. Suppress individual rules via #pragma, .editorconfig, or [SuppressMessage].

QRA1xx — Simplification

ID	Title	Severity	What it detects
QRA101	Count compared to zero	Info	`Count() > 0`, `Count() == 0` — use `Any()` instead
QRA102	Single-value IN clause	Info	`IN (@p0)` with one value — simplify to `==`
QRA103	Tautological condition	Info	Always-true conditions (`1 = 1`, `col = col`)
QRA104	Contradictory condition	Info	Always-false conditions (`x > 5 AND x < 3`)
QRA105	Redundant condition	Info	Subsumed conditions (`x > 5 AND x > 3`)
QRA106	Nullable without null check	Info	Nullable column in `==` comparison without null handling

QRA2xx — Wasted Work

ID	Title	Severity	What it detects
QRA201	Unused join	Warning	Joined table not referenced in SELECT, WHERE, or ORDER BY
QRA202	Wide table SELECT *	Info	`Select(u => u)` on tables exceeding column threshold
QRA203	ORDER BY without LIMIT	Info	Sorting without pagination on unbounded result sets
QRA204	Duplicate projection column	Info	Same column projected multiple times in SELECT
QRA205	Cartesian product	Warning	JOIN with missing or trivial ON condition (`1 = 1`)

QRA3xx — Performance

ID	Title	Severity	What it detects
QRA301	Leading wildcard LIKE	Info	`Contains()` → `LIKE '%…%'` prevents index usage
QRA302	Function on column in WHERE	Info	`LOWER()`, `UPPER()`, `TRIM()`, etc. on columns in WHERE
QRA303	OR across different columns	Info	`col1 = x OR col2 = y` prevents single-index scan
QRA304	WHERE on non-indexed column	Info	Filter on column not covered by any declared index

QRA4xx — Patterns

ID	Title	Severity	What it detects
QRA401	Query inside loop	Warning	Execution method inside `for`/`foreach`/`while`/LINQ — N+1 risk
QRA402	Multiple queries on same table	Info	Multiple independent queries on the same entity in one method

QRA5xx — Dialect

ID	Title	Severity	What it detects
QRA501	Dialect optimization available	Info	PostgreSQL: suggest `ILIKE` over `LOWER() + LIKE`; SQLite: suggest `COLLATE NOCASE`
QRA502	Suboptimal for dialect	Warning	SQLite: `RIGHT JOIN` unsupported; SQL Server: `OFFSET` requires `ORDER BY`

Configuration

EditorConfig

# .editorconfig
[*.cs]
# Column threshold for QRA202 (wide table SELECT *), default: 10
quarry_analyzers.wide_table_column_count = 12

Suppressing Rules

# .editorconfig — suppress a rule project-wide
[*.cs]
dotnet_diagnostic.QRA203.severity = none

// Per-site suppression
#pragma warning disable QRA301
var results = await db.Users
    .Where(u => u.UserName.Contains(search))
    .ExecuteFetchAllAsync();
#pragma warning restore QRA301

Severity Summary

Four rules default to Warning — these indicate likely bugs or significant performance issues:

ID	Rule
QRA201	Unused join
QRA205	Cartesian product
QRA401	Query inside loop (N+1)
QRA502	Suboptimal for dialect

The remaining 14 rules default to Info — suggestions that may or may not apply depending on context.

There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

.NETStandard 2.0
- No dependencies.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on Quarry.Analyzers:

Package	Downloads
Quarry.Analyzers.CodeFixes Package Description	89

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last Updated
0.1.0	125	3/13/2026