json-extract

JSON_TABLE() in MySQL 8 converts JSON arrays into relational rows, enabling standard GROUP BY, JOIN, and aggregate operations. This guide compares it with JSON_EXTRACT and application-side processing, analyzes when to use each approach, with real-world examples including NESTED PATH and inconsistent data handling.