[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1207) Merge the relational and function metamodels

Merge the relational and function metamodels -------------------------------------------- Key: TEIIDDES-1207 URL: https://issues.jboss.org/browse/TEIIDDES-1207 Project: Teiid Designer Issue Type: Quality Risk Components: Modeling Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Dan Florian Fix For: 8.0 Having the function and relational models is no longer necessary. We can add the needed function metadata (including TEIIDDES-152 vararg support, null-on-null, etc.) through either extension properties or a metamodel change. This is in the vain of PostgreSQL which uses the create function syntax to add what would be procedures in other dbmses. Virtual functions (procedures marked as functions in a view layer) could also still specify transformation sql if pushdown is not required - rather than forcing the use of a java class. We could deprecate the old function model support of the Teiid side then.