Since version 8.0.14, MySQL supports LATERAL derived tables, sometimes called the for each loop of SQL. What are they? How do they work? Why do you need them? What can they do? How can you use them? Should you use them? What is all this talk about for each loops?
In this session we'll explain the concepts, look at examples of how and when to use this new feature, and talk about how LATERAL derived tables are optimized and executed by MySQL.
Norvald has been at Oracle since 2011 and is the MySQL optimizer
team lead, responsible for query optimization and execution. He holds a
PhD in Computer and Information Science from the Norwegian University of
Science and Technology.