Hello
I have been testing the SQL plugin in OpenSearch to query JSON data stored inside indices. 
While it works well for simple fields, I’m running into trouble when the JSON is deeply nested or has arrays of objects. Some queries become very long and hard to manage, and in a few cases, the results don’t come back in the format I expect.
I’m curious if other users have a reliable way to flatten or query these structures more efficiently. Should I transform the data before indexing, or is there a smarter way to query it directly through SQL functions in OpenSearch? 
Checked SQL - OpenSearch Documentation guide for reference.
During my research, I even looked at what is javascript, since JavaScript is great for parsing JSON, and I wondered if similar approaches or integrations might help when working with OpenSearch SQL.
If anyone has experience with best practices for dealing with complex JSON inside the SQL plugin—such as indexing strategies, query examples, or performance tips—I’d love to hear your thoughts.
This could really help others who are facing the same challenges when handling semi-structured data.
Thank you !!