I wanted to use REPLACE() mssql function. When I added it into model, it threw an error explaining the dbo.replace function doesn’t exist in the db. I had to create a new user-defined dbo.replace function in the db, that proxy the system REPLACE functionality. It would be great if Origam was extendable easier for the similar purposes.
Correct and would be great. When implementing we must remember that system functions would have to be modelled in a way that they would be cross-database compatible. That’s why today some of the core functions are hardcoded and rendered by code while the rest is just considered a custom function that is supposed to be implemented equally on any database.
So your solution is currently good as the custom function separates it well from the model, although I guess it performs poorly.