(Dave Stokes) JSON_TABLE is one of the more complex functions that arrived in MySQL 8. It takes schemaless JSON data and turns it into a relational table. So your NoSQL data becomes SQL data and you can use good ol’ SQL where clauses on that temporary relational table!
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help