add-cel-feature

Add CEL functions, operators, or macros to pycel2sql across SQL dialects.

Updated Feb 26, 2026
One-click install
npx skills add https://github.com/SPANDigital/pycel2sql --skill add-cel-feature
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: add-cel-feature
Source: https://github.com/SPANDigital/pycel2sql/tree/main/.claude/skills/add-cel-feature
Command: npx skills add https://github.com/SPANDigital/pycel2sql --skill add-cel-feature

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps extend the functionality of pycel2sql by adding new Common Expression Language (CEL) features, such as functions, operators, macros, or comprehension forms.

Core Features & Use Cases

  • Functionality Extension: Add new CEL functions, operators, macros, or comprehension forms.
  • Dialect Support: Implement new features across all supported SQL dialects (PostgreSQL, MySQL, SQLite, DuckDB, BigQuery, Apache Spark).
  • Test Coverage: Ensure comprehensive test coverage across all dialects to maintain functionality and compatibility.

Quick Start

To add a new CEL function, follow these steps:

  1. Classify the feature (function, operator, macro, or comprehension).
  2. Identify the visitor method in _converter.py.
  3. Decide if a new Dialect method is needed.
  4. Implement the feature and test cases across all dialects.

Frequently Asked Questions about add-cel-feature

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I add new CEL functions to pycel2sql?

To add new CEL functions to pycel2sql, classify the feature, locate the visitor method in `_converter.py`, decide if a new `Dialect` method is required, then implement the feature and tests across all supported SQL dialects.

Does pycel2sql support adding custom operators across multiple SQL dialects?

Yes, pycel2sql supports adding custom operators across PostgreSQL, MySQL, SQLite, DuckDB, BigQuery, and Apache Spark, requiring you to implement the new operators in `_converter.py` and ensure comprehensive test coverage for each dialect.

What is the process to extend Common Expression Language macros in a Python SQL converter?

Extending Common Expression Language macros involves modifying the `_converter.py` file to identify the relevant visitor method, implementing the macro logic, and validating the SQL conversion behavior across all supported dialects.

Can I implement new CEL comprehension forms and test them across all SQL dialects?

Yes, you can implement new CEL comprehension forms by updating the converter logic and writing comprehensive test cases to maintain functionality and compatibility across PostgreSQL, MySQL, SQLite, DuckDB, BigQuery, and Apache Spark.

When do I need to create a new Dialect method for a pycel2sql functionality extension?

You need to create a new Dialect method during a pycel2sql functionality extension when the new CEL feature requires specific SQL syntax variations that cannot be handled by the default visitor logic in `_converter.py`.

What are the limitations when extending CEL features for SQL dialect support?

The primary limitation when extending CEL features is the requirement to maintain compatibility and comprehensive test coverage across all six supported SQL dialects, ensuring the new functions, operators, or macros do not break existing conversion logic.