Can you share the query plan?
What mode are you running in the query in(Logical/ODBC/Display)
Maybe someone is looking for job security.
Regarding
You will miss out on DTL specific functions (example lookups), albeit you could call the look up code in COS
some might think that using classes with COS code is better as it allows you to call any funtion you like. I think that's demonstrating a lack of knowledge. If you created a class that extends Ens.Rule.FunctionSet , the functions then become available to anyone using the DTL or Rule Editor.
Additionally the new Rule Editor allows for ForEach whch otherwise might have been difficult to implement in the past.
I'd much rather be spending my time working on more advanced parts of an implementation instead of DTLs and Rules.
The only odd thing about DTLs and Rules is when you ask a business analyst to be involved they might not feel as strongly about following a rigorous CI/CD process. In my experience, some folks like to make changes to the DTLs and Rule and not commit to a feature branch and promote up thru the different environment(TEST,STAGE,PROD) as would normally be done if one was striclty in a class, even thought DTLs and Rules are in fact classes.









Yes this is true and a formal way to do this is really the thing you queue, whether a function or a class method should return a %Status to signal to the wqm that an error occured. In practice the usage of wqm.Queue should not only call a function or class method but pass some parameters. I often times have my function/class method act on a collection/list of rowids so my call to .Queue includes the function/classmethod as well as the list of rowids to process.