I thought it is easy to merge json arry to mysql but I can't find a good reference so far. Also, I know MySQL 8.0 is supporting this easily but unfortuniately, my own version is still 5.7.x. So, let ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses.