Class SqlNormalizer

Namespace

QueryGuard

Assembly

QueryGuard.Core.dll

The default ISqlNormalizer: a single conservative pass over the text.

public sealed class SqlNormalizer : ISqlNormalizer

Inheritance

object

SqlNormalizer

Implements

ISqlNormalizer

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

What it does, and nothing more:

1. collapses runs of whitespace, including line breaks, to a single space;
2. removes comments, except a recognized QueryGuard: directive;
3. replaces provider parameter references with a single placeholder;
4. drops the statement terminators and batch prologue some providers prepend.

What it deliberately never does: reorder tokens, sort clauses, canonicalize aliases, rewrite quoted identifiers, or attempt to recognize that two differently written statements are semantically equivalent. Each of those would risk merging genuinely different queries, and a report that points at the wrong SQL is worse than one that stays quiet.

String literals and quoted identifiers are copied through untouched. Redacting literals is the redactor's job, applied after normalization, so there is exactly one place that decides what counts as data.

Fields

ParameterPlaceholder

Replaces every provider parameter reference, whatever its syntax.

Methods

Normalize(string?)

Normalizes a command's text.