.agents/skills/query-pipeline/SKILL.md
Translates LINQ expressions into database queries and materializes results.
QueryTranslationPreprocessor: NavigationExpandingExpressionVisitor (Include, navigations, auto-includes), QueryOptimizingExpressionVisitorQueryableMethodTranslatingExpressionVisitor: LINQ methods → ShapedQueryExpression (= QueryExpression + ShaperExpression). Relational: RelationalSqlTranslatingExpressionVisitor, SelectExpressionQueryTranslationPostprocessor: SqlNullabilityProcessor, SqlTreePruner, SqlAliasManager, RelationalParameterBasedSqlProcessor, SelectExpressionProjectionApplyingExpressionVisitor, SqlExpressionSimplifyingExpressionVisitor, RelationalValueConverterCompensatingExpressionVisitorShapedQueryCompilingExpressionVisitor → executable delegate. Relational: ShaperProcessingExpressionVisitor builds shaper and materialization codeQuerySqlGeneratorToQueryString() shows generated SQL without executingExpressionPrinter dumps expression trees at any pipeline stageAssertSql() in provider functional tests and the generated SQL corresponds to the LINQ query in the base method