Query Functions

cPath, cQL and cQuery share the same Query Functions, which are primarily based on ANSI SQL and many MySQL extensions, but also include some content- and object-oriented extensions unique to webCOMAND.

While a significant number of SQL functions are implemented, more can and will be added to io_comand_repo to improve coverage and compatibility with ANSI SQL and other common extensions.

To implement a new function:

1. Add function to $operators in io_comand_repo/cql_compiler/expression/compiled/operation.php
2. Add function to $functions in io_comand_repo/cql_compiler/expression/shared_base.php
3. Add corresponding "eval_" function to io_comand_repo/storage/sql/sql_builder.php
4. Add corresponding "eval_" function to io_comand_repo/collection.php
5. Add function prototype to io_comand_repo/cql_compiler/expression/compiled/evaluator.php

Shared Functions

While cPath, cQL and cQuery share the same functions, the goal is to eventually offer a common set of functions across cCell, cPath, cQL, cQuery, cScript and cTemplate wherever possible, while striving for maximum compatibility with other spreadsheet and SQL implementations, and JavaScript/PHP function libraries.

An invite-only online spreadsheet is maintained and evolved to help organize that massive on-going effort.  To request access, please contact us.

• < PHP Methods
• Temporal Queries >