devops
End-to-end playbook for implementing a feature or fix in pgx-lower. Auto-invoke when the user says "start spec NN", "implement spec NN", or asks for any code change that should end in a pull request. Covers spec claiming, worktree creation, TDD, build, static analysis, tests, benchmark, PR, and status-board upkeep. The user only ever says "start spec NN" — every other step is yours.
Repository SourceNeeds Review
architecture-ast-translation
How PostgreSQL plan trees (PlannedStmt) are translated into MLIR RelAlg by PostgreSQLASTTranslator. Plan node coverage, expression translation dispatch, the TranslationContext, schema/type mapping. Use when adding plan node support, debugging "unsupported plan node type" errors, working on expression translation, or touching anything in src/pgx-lower/frontend/SQL/.
Repository SourceNeeds Review
architecture-jit-compilation
The LLVM JIT engine, optimization pipeline, ExecutionEngine lifecycle, MLIR→LLVM IR translation, and the per-query compile flow. Use when working on jit_execution_engine.cpp, LLVM passes, JIT compilation issues, ExecutionEngine ownership, function lookup, or symbol resolution.
Repository SourceNeeds Review
architecture-mlir-dialects
The four MLIR dialects (RelAlg, DB, DSA, util) used by pgx-lower, their key types and ops, and the lowering pipeline (RelAlg → DB+DSA+Util → Standard → LLVM). Use when adding ops, debugging lowering passes, working on dialect types, touching anything in src/lingodb/mlir/, or wondering where a particular op lowers.
Repository SourceNeeds Review