Skip to content

Allow for basic SQL queries as Rule Check logic (before SQL refactor) #1339

@gerrycampion

Description

@gerrycampion
  • Add a new rule type "SQL"
  • engine will do preprocessing to assign record numbers to the dataset frames for reporting
  • we can make use of duckdb.query, which allows sql queries on pandas dataframe variables. (This will change in the future after the sql refactor).
  • the reporting functionality will use the generated record numbers and other columns to populate the report
  • Add documentation for the new rule type
  • Check property will allow a SQL select query that returns the records that violate the rule. This will replace the business rules engine process of using a list of booleans.
  • Scope will remain the same in terms of selecting datasets within scope, (unlike with jsonata)
  • We will want to support only ANSII sql to make future compatible with other flavors of sql

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions