In the latest version of SingleStoreDB Self-Managed, version 6.8, several query processing capabilities have been enhanced to improve performance and user experience. The marquee feature is just-in-time (JIT) compilation, which speeds up query runtimes on the first run of a query, now turned on by default. This feature can greatly improve the user's experience running ad hoc queries or when using applications that cause a lot of new SQL statements to be run. Additionally, performance improvements have been made in certain right and left outer joins, Rollup and Cube, as well as sub-select without an alias and extended Oracle compatibility for date and time handling functions. New array functions for splitting strings and converting JSON data are also added. Furthermore, the resource governor has been extended to better manage resources for more operations, and new built-in functions have been introduced, including SPLIT() and JSON_TO_ARRAY(). Overall, these enhancements aim to provide improved performance, user experience, and compatibility with various databases and applications.