cdisc-org / cdisc-org/cdisc-rules-engine

SQL UDFs and Procedural language

Open
#1,343 0 comments 0 reactions 0 assignees View on GitHub
SQL
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.