SPANDigital

Adds new CEL operator, function, macro, or comprehension support to cel2sql across all SQL dialects, touching cel2sql.go visit*, the dialect.Dialect interface, every dialect/<name>/dialect.go, and testcases/<category>_tests.go. Use when wiring a new CEL function (e.g., string.toLowerCase, timestamp.toISOString), a new comprehension form, a new operator overload, or extending the converter to recognise a CEL extension package.

Adds a new SQL dialect to cel2sql by registering its name, implementing the Dialect interface in dialect/<name>/, adding a sibling type provider in <name>/, populating shared test cases in testcases/, and refreshing README.md and CLAUDE.md. Use when adding any new database backend (Trino, Snowflake, ClickHouse, MS SQL, Athena, Oracle) or porting cel2sql to another analytics engine.

Cuts a new cel2sql release by preparing CHANGELOG.md, deciding the semver bump from commit history, opening a release-prep PR, then tagging and pushing after merge to trigger .github/workflows/release.yml. Use when shipping any new patch, minor, or major version of cel2sql.

Authors and reviews agent skills for this repo, enforcing progressive disclosure (metadata → instructions → resources), ≤500-line SKILL.md files, domain-split references, scripts over prose for deterministic work, and specific third-person descriptions. Use when creating a new skill, splitting an oversized SKILL.md, or reviewing an existing skill for structure.

Cuts a new pycel2sql release by validating the working tree, picking the semver bump, tagging vX.Y.Z, and pushing the tag to trigger .github/workflows/release.yml which runs CI, builds an sdist + wheel via hatch-vcs, and publishes to PyPI via OIDC trusted publishing. Use when shipping a new patch, minor, or major version of pycel2sql to PyPI.

Ports features and bug fixes from upstream cel2sql Go (the canonical source) and cross-references cel2sql4j Java into pycel2sql. Use when syncing upstream changes — the workflow enumerates candidate commits since the last sync, verifies whether each change is already applied (many turn out to be done already), maps Go and Java idioms to Python equivalents, ports the test, and updates relevant docs.

Adds a new CEL function, operator, macro, or comprehension form to pycel2sql by extending Converter visit methods in src/pycel2sql/_converter.py, deciding whether a new Dialect ABC abstract method is needed, implementing it across all six dialects when SQL diverges, and adding parametrized test cases. Use when wiring a new CEL string method (toLowerCase, isAlpha), timestamp method (toISOString), free-function helper, operator overload, or comprehension form across PostgreSQL, MySQL, SQLite, DuckDB, BigQuery, and Apache Spark.

Adds a new SQL dialect to pycel2sql by creating src/pycel2sql/dialect/<name>.py (subclass of the Dialect ABC), registering in the DialectName enum and the get_dialect() factory, threading new test cases through every parametrized test class, and updating the README badge grid and dialect-comparison tables. Use when porting a new database backend (Trino, Snowflake, ClickHouse, MS SQL, Athena, Oracle) or any new analytics engine.

Cuts a new cel2sql4j release by validating the working tree, picking the semver bump, tagging `vX.Y.Z`, and pushing the tag to trigger `.github/workflows/release.yml` which runs tests and publishes to Maven Central via the vanniktech publish plugin. Use when shipping a new patch, minor, or major version of cel2sql4j to Maven Central.

Adds a new CEL standard library function (or operator) to cel2sql4j across all six SQL dialects. Use when implementing a CEL function such as `trim`, `format`, `getMonth`, `lowerAscii`, or any new operator that requires per-dialect SQL output — the workflow touches `Converter.java` constants and dispatch, the `Dialect` interface, every dialect implementation (postgres, mysql, sqlite, duckdb, bigquery, spark), and the parameterized test class for that function category.

Adds a new SQL dialect to cel2sql4j (CockroachDB, Snowflake, Redshift, ClickHouse, etc.) by scaffolding the dialect package with `<Name>Dialect` / `<Name>Validation` / `<Name>Regex` classes, registering the dialect in the `DialectName` enum, deciding whether to implement `IndexAdvisor`, threading new test cases through every dialect-looping test class, and updating the README badge grid and dialect-comparison tables. Use when porting a new database target.

Ports features and bug fixes from the upstream Go library github.com/spandigital/cel2sql (locally checked out at /Users/richardwooding/Code/SPAN/cel2sql) into the Java cel2sql4j port. Use when syncing upstream changes — the workflow enumerates candidate commits since the last sync, verifies whether each change is already applied (many turn out to be done already), maps Go idioms to Java equivalents, and updates tests plus the "Differences from upstream" section in CLAUDE.md.

Use when creating, developing, building, or troubleshooting websites with the Hugo static site generator.

Use when designing, debugging, or refactoring Hugo layouts, partials, lookup rules, render hooks, and asset pipelines at an expert level.