feat(reporting-service): supports subqueries, multilevel function, da…

[SouravSF]

feat(reporting-service): supports subqueries, multilevel function, dataset filter, sql in dataset

MIGRATION CHANGE: migration-20240408121519- adds new column data_set_query_sql in datasets table

BREAKING CHANGE: updated StructuredQueryInterface

Description

Please include a summary of the change and which issue is fixed. Please also include relevant motivation and context. List any dependencies that are required for this change.

Fixes # (issue)

Type of change

Please delete options that are not relevant.

• [ ] Bug fix (non-breaking change which fixes an issue)
• [ ] New feature (non-breaking change which adds functionality)
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] Intermediate change (work in progress)

How Has This Been Tested?

Please describe the tests that you ran to verify your changes. Provide instructions so we can reproduce. Please also list any relevant details for your test configuration

• [ ] Test A
• [ ] Test B

Checklist:

• [ ] Performed a self-review of my own code
• [ ] npm test passes on your machine
• [ ] New tests added or existing tests modified to cover all changes
• [ ] Code conforms with the style guide
• [ ] API Documentation in code was updated
• [ ] Any dependent changes have been merged and published in downstream modules

[sonarqubecloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
0.0% Duplication on New Code

See analysis details on SonarCloud

[sonarqubecloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud

[yeshamavani]

Approved by @akshatdubeysf