[FEATURE] Improve exception handling for incorrect DQ rules

[IMC07]

Is your feature request related to a problem? Please describe.
Formulating the data quality rule correctly can sometimes be challenging. Having better error handling for wrongly formulated rules can help. For instance I had this error:

The problem appeared to be that I had accidentally set the rule_type=query_dq, but it should have been rule_type=row_dq. Perhaps there is a way for these (and similar other common pitfalls) to identify the issue easier with more fine-grained exception handling.

Describe the solution you'd like
For example, define new exception types something like this:
Invalid Query DQ Exception: 'The DQ expection [rule-name] can not be executed, please check the type and formulation of your DQ rule'
Invalid Row DQ Exception: ...
Invalid Query DQ Exception: ...

Describe alternatives you've considered

Additional context