Join/From clauses should not contain subqueries. Use CTEs instead.

Fully qualify JOINs.

Inconsistent column references in GROUP BY/ORDER BY clauses.

All queries in set expression should return the same number of columns.

Ambiguous use of DISTINCT in select statement with GROUP BY.

Check if LIMIT and OFFSET are used without ORDER BY.

Look for UNION keyword not immediately followed by DISTINCT or ALL. Note that UNION DISTINCT is valid, rule only applies to bare UNION.

Find joins without ON clause. Fix them into CROSS JOIN (if dialect allows it).

Ambiguous ordering directions for columns in order by clause. This rule checks if some ORDER BY columns explicitly specify ASC or DES

Outermost query should produce known number of columns.

Inconsistent capitalisation of keywords. We use the `memory` feature here to keep track of cases known to be INconsistent with what w

Inconsistent capitalisation of datatypes. We use the `memory` feature here to keep track of cases known to be inconsistent with what

Override base class for dialects that use structs, or SELECT aliases.

Keywords should not be used as identifiers.

Unnecessary quoted identifier.

Do not use special characters in object names.

Find rule violations and provide fixes.

Relational operators should not be used to check for NULL values.

Statements must end with a semi-colon.

Use LEFT JOIN instead of RIGHT JOIN.

Enforce consistent "not equal to" style.

Trailing commas within select clause.

Use ``COALESCE`` instead of ``IFNULL`` or ``NVL``.

Top-level statements should not be wrapped in brackets.

Enforce consistent type casting style.

Find joins with WHERE clause. Fix them into JOIN ON.

Procedure bodies with multiple statements should be wrapped in BEGIN/END.

Remove empty batches.

r"""``SP_`` prefix should not be used for user-defined stored procedures.

We should not ORDER BY forbidden_columns.

Roughly generate test segments. This function isn't totally robust, but good enough for testing. Use with caution.

Cache the hash property to avoid recalculating it often.

For the parallel runners indicate that we're not in the main thread.

Extract the elements of a reference and yield.

Load ignore specs from a standard config file. This function leverages the caching used in the config module to ensure that anything loaded h

Load a sqlfluffignore file, returning the parsed spec.

Map using imap unordered. We use this so we can iterate through results as they arrive, and while other files are still being process

Map using imap. We use this so we can iterate through results as they arrive, and while other files are still being processed.

Use regexes to match chunks.

Returns only the non-comment elements of this segment.

Create a dummy render func. Importantly one that does actually allow different content to be added.

Return an instance of the class itself. Args: *args: Variable length argument list. **kwargs: Arbitrary keyword argum

Return any extra output required at the end when logging. Meta classes have not much to say here so just stay blank.

If present, output the block uuid.

Also output what it's a placeholder for.

Return any extra output required at the end when logging. NB Override this for specific subclasses if we want extra output. Returns:

Return any extra output required at the end when logging. NB Override this for specific subclasses if we want extra output.

This validates one or multiple statements against specified segment class. It even validates the number of parsed statements with the number of e

Hook to add the permalink and index entries.

Do all the templated slices match?

Do all the raw slices match?

Do any of the templated slices match?

Do any of the raw slices match?

Return cache hit rate as float 0-1.

A string to use for cache keying. This string should be unique at the parsing stage such that if there has already been a match again

Get the cache key for the matcher. NOTE: In this case, this class is a bit of a singleton and so we don't need a unique UUID in the s

Get the cache key for the matcher.

Return the cache key for this segment definition. NOTE: The key itself is generated on _definition_ by the metaclass.

A decorator to cache the output of this method for a given parse context. This cache automatically invalidates if the uuid of the parse conte

Make a list of check_tuples. This assumes that all the violations found are linting violations. If they don't then this function

Fetch all check_tuples from all contained `LintedDir` objects. Returns: A list of check tuples.

Fetch all check_tuples from all contained `LintedDir` objects. Returns: A dict, with lists of tuples grouped by path.

Get the set of contained class types. Parallel to `BaseSegment.class_types`

The set of full types for this segment, including inherited. Add the surrogate type for raw segments.

The set of types for this segment.

Clear up the tests directory. NB: Using scripts allows platform independence Makes a new one afterward

Autoformat SQL files. This effectively force applies `sqlfluff fix` with a known subset of fairly stable rules. Enabled rules are ignored, bu

Close output stream.

Optionally use ANSI colour codes to colour a string.

Add common options to commands via a decorator. These are applied to all of the cli commands.

Copy this Matchable. Matchable objects are usually copied during dialect inheritance. One dialect might make a copy (usually with som