Stored procedural objects, including stored procedures, user-defined scalar-value functions (UDFs), user-defined table-valued functions (TVFs), and user-defined aggregate functions (UDAFs), are available in SingleStore to achieve performance and business objectives by storing compiled code inside the database. Stored procedures can manipulate data in a table and return single values like UDFs, as well as query-type values. Functions like UDFs and TVFs provide a wide range of capabilities for customer logic sets, while external functions are maintained and executed outside SingleStore's internal services. Aggregates, such as UDAFs, enable the execution of programmatic logic in the function body to return scalar-type values.