Interleaved execution infrastructure in database engines

A method comprising:

• receiving, by a network-based data system, a query;
• generating, by at least one server in the network-based data system, a query plan to execute the query;
• detecting a plan fragment of the query plan for early execution, the plan fragment comprising a dynamic resolving object, the dynamic resolving object comprising a macro expression;
• pausing compilation of the query plan based on detecting the plan fragment;
• assigning, by the at least one server, the plan fragment to one or more execution platforms in the network-based data system for execution;
• executing, by one or more execution platforms in the network-based data system, the plan fragment while the compilation of the query plan is paused, the executing comprising:
• expanding a definition of a user defined function (UDF) in the plan fragment;
• executing the macro expression based on the expanded definition;
• and
• generating results based on executing the macro expression, the results comprising at least one generated definition of the UDF;
• receiving, by the at least one server, results of executing the plan fragment from the one or more execution platforms;
• modifying, by the at least one server, the compilation of the query plan based on the results;
• and
• completing compilation of the query plan.

A machine-storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:

• receiving, by a network-based data system, a query;
• generating, by at least one server in the network-based data system, a query plan to execute the query;
• detecting a plan fragment of the query plan for early execution, the plan fragment comprising a dynamic resolving object, the dynamic resolving object comprising a macro expression;
• pausing compilation of the query plan based on detecting the plan fragment;
• assigning, by the at least one server, the plan fragment to one or more execution platforms in the network-based data system for execution;
• executing, by one or more execution platforms in the network-based data system, the plan fragment while the compilation of the query plan is paused, the executing comprising:
• expanding a definition of a user defined function (UDF) in the plan fragment;
• executing the macro expression based on the expanded definition;
• and
• generating results based on executing the macro expression, the results comprising at least one generated definition of the UDF;
• receiving, by the at least one server, results of executing the plan fragment from the one or more execution platforms;
• modifying, by the at least one server, the compilation of the query plan based on the results;
• and
• completing compilation of the query plan.