User defined functions for data loading

A computer-implemented method for data loading, the method comprising:

• receiving, at a computing device, a call to a table valued user defined function within a structured query language (SQL) statement that includes an insert statement;
• processing the call, using the computing device, to validate and resolve a subclass type of the table valued user defined function based on metadata associated with the table valued user defined function;
• and
• generating, using the computing device, a data loading plan to retrieve and load data from a data source that is external to the computing device based on the subclass type of the table valued user defined function, the data loading plan including the table valued user defined function;
• and
• executing, using the computing device, the data loading plan to retrieve the data and load the retrieved data into a table in accordance with the data loading plan.

A non-transitory computer-readable storage medium Storing instructions that, when executed by a processor, cause the processor to:

• receive a call to a table valued user defined function within a structured query language (SQL) statement that includes an insert statement;
• process the call to validate and resolve a subclass type of the table valued user defined function based on metadata associated with the table valued user defined function;
• and
• generate a data loading plan to retrieve and load data from an external data source based on the subclass type of the table valued user defined function, the data loading plan including the table valued user defined function;
• and
• execute the data loading plan to retrieve the data and load the retrieved data into a table in accordance with the data loading plan.