cdisc-org / cdisc-org/cdisc-rules-engine
SQL UDFs and Procedural language
- Dominant language
- Python
- Stars
- 113
- Forks
- 43
- Avg merge
- 14h 51m
- Merged PRs (30d)
- 14
Description
We will need to support a way to write custom user-defined functions https://www.postgresql.org/docs/current/xfunc-sql.html. These will work in a similar way to the current check operators. Additionally, some rules (CG0019) require the use of metadata to create queries. In order to do this, we will require a way of supporting a procedural language. We may be able to support user defined procedures the same way we support user defined functions.
- Postgresql supports 4 procedural languages. https://www.postgresql.org/docs/current/xplang.html. We will need to choose between:
- a sql-like language in the rule yaml
- a python language (PL/Python) in an external folder or repo. This would be similar to how we handle operations and operators
Contributor guide
Assessment
This issue has not been assessed yet.