LATERAL Derived Tables in MySQL 8.0

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.