Is it possible to split Individual elements of JSON query into separate rows in different table?

You can use Glide API directly from the app. Here a resource I made that explain how to do that: Bulk Edit Column Values Across Multiple Rows in Glide with User-Specific Column Compatibility

You must change the kind set column values to add row.