Brief summary of the change made

This fixes a number of issues with ST05:

• Conflicts with other rules such as ST06, LT08, and LT09
• Supports the CTE spacing with LT08 on the first pass
• The handling of orders on some fixes
• Allowed for partial fixes when some aliases had the same name

Linked Issues:

• fixes Rule L042 creates CTE in incorrect position #4137
• fixes SQLFluff fix deleting CTEs when config includesforbid_subquery_in = both #4782
• fixes structure.subquery rule breaks CTEs #5265
• makes progress on Result of fix changes on subsequent runs (fix is non-deterministic) when fix creates new CTE. #6502

Are there any other side effects of this change that we should be aware of?

None, but this does make ST05 use the BaseSegment._position_segments which is maybe less than ideal.

Pull Request checklist

• Please confirm you have completed any of the necessary steps below.

• Included test cases to demonstrate any code changes, which may be one or more of the following:

  • .yml rule test cases in test/fixtures/rules/std_rule_cases.
  • .sql/.yml parser test cases in test/fixtures/dialects (note YML files can be auto generated with tox -e generate-fixture-yml).
  • Full autofix test cases in test/fixtures/linter/autofix.
  • Other.

• Added appropriate documentation for the change.

• Created GitHub issues for any relevant followup/future enhancements if appropriate.