[teiid-issues] [JBoss JIRA] (TEIID-3421) Add ability to create Teiid language based custom functions

[Marc Shirley (JIRA)]

Marc Shirley created TEIID-3421:
-----------------------------------

             Summary: Add ability to create Teiid language based custom functions
                 Key: TEIID-3421
                 URL: https://issues.jboss.org/browse/TEIID-3421
             Project: Teiid
          Issue Type: Feature Request
            Reporter: Marc Shirley
            Assignee: Steven Hawkins


Add the capability to create user defined functions that do not require Java backing.  Use case would be something like a library of string manipulation functions such as separating a username or domain from an email address. For example:
BEGIN
	SELECT substring(inputValue, 0, (locate('@', inputValue) - 1)) AS username;
END

Once the function is defined in the function library model, the user would then be able to utilize the functions in ad hoc queries like the below:
SELECT getUsername(email) as username ...



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)