JIT Compiling Code in 5μs

JIT compilation, historically requiring deep assembly knowledge, is now more accessible with AI assistance, enabling fast compile times (around 5 microseconds) that allow every SQL query to be compiled rather than just a subset. The author demonstrates this by building a fast JIT compiler for pgrust and explains how JIT compilation leverages runtime information to achieve significant performance improvements, using a simplified regular expression engine as an example. This approach represents a new opportunity for databases to outperform legacy systems that rely on slower LLVM or C/C++ code generation.