SingleStoreDB Self-Managed 6 Beta 1 has introduced a new feature called Procedural SQL, which supports the creation of user-defined functions (UDFs), stored procedures (SPs), table-valued functions (TVFs), and user-defined aggregate functions (UDAFs). This allows for more convenient programming with arrays, which can be declared and initialized using simple language constructs such as `declare a array(int) = create_array(10);`. Arrays in SingleStoreDB Self-Managed 6 Beta 1 are zero-based, meaning the positions of the array are numbered starting from 0. The compiler uses type inference to determine the data type of the array based on the variable being assigned to it. This feature enables performance-optimized code generation and can sort large arrays quickly. Multidimensional arrays with "ragged" sub-arrays are also supported, allowing for more complex data structures. Overall, arrays in SingleStoreDB Self-Managed 6 Beta 1 provide a powerful toolset for developers to create efficient and expressive code.